Oracle apps EBS r12 Report for the HRMS and
Payroll Report –
Employee Master Report
Template
File - xls File Design :
Format Like This.
Data
Definition xml File :
---------------------
XXBEXEMPLMASTERDATAREP.xml----------------------
<?xml
version="1.0" encoding="UTF-8" ?>
<dataTemplate name="XXBEXEMPLMASTERDATAREP"
version="1.0">
<properties>
<property name="xml_tag_case"
value="upper" />
<property
name="scalable_mode" value="on" />
</properties>
<parameters>
<parameter
name="P_EFFECTIVE_DATE" dataType =
"varchar2"></parameter>
<parameter
name="P_PERSON_ID" dataType =
"VARCHAR2"></parameter>
<parameter
name="P_LEGAL_ENTITY" dataType =
"varchar2"></parameter>
<parameter
name="P_PERSON_TYPE_ID" dataType =
"varchar2"></parameter>
<parameter
name="P_ORGANIZATION_ID" dataType =
"varchar2"></parameter>
<parameter
name="P_GRADE_ID" dataType = "varchar2"></parameter>
<parameter
name="P_LOCATION_ID" dataType =
"varchar2"></parameter>
</parameters>
<dataQuery>
<sqlStatement
name="Q_EMPL">
<![CDATA[
SELECT empl.*,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,1) +1,instr(empl.permanent_address,'|',1,2)-instr(empl.permanent_address,'|',1,1)-1)
perm_flat_no,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,2)
+1,instr(empl.permanent_address,'|',1,3)-instr(empl.permanent_address,'|',1,2)-1)
perm_block_road_no,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,3)
+1,instr(empl.permanent_address,'|',1,4)-instr(empl.permanent_address,'|',1,3)-1)
perm_area_village,
initcap(SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,4)
+1,instr(empl.permanent_address,'|',1,5)-instr(empl.permanent_address,'|',1,4)-1))
perm_country,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,5)
+1,instr(empl.permanent_address,'|',1,6)-instr(empl.permanent_address,'|',1,5)-1)
perm_postal_code,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,6)
+1,instr(empl.permanent_address,'|',1,7)-instr(empl.permanent_address,'|',1,6)-1)
perm_city,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,7)
+1,instr(empl.permanent_address,'|',1,8)-instr(empl.permanent_address,'|',1,7)-1)
perm_post_office,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,8)
+1,instr(empl.permanent_address,'|',1,9)-instr(empl.permanent_address,'|',1,8)-1)
perm_police_station,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,9)
+1,instr(empl.permanent_address,'|',1,10)-instr(empl.permanent_address,'|',1,9)-1)
perm_district,
SUBSTR(empl.permanent_address,instr(empl.permanent_address,'|',1,10)+1)
perm_section,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,1) +1,instr(empl.present_address,'|',1,2)-instr(empl.present_address,'|',1,1)-1)
present_flat_no,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,2)
+1,instr(empl.present_address,'|',1,3)-instr(empl.present_address,'|',1,2)-1)
present_block_road_no,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,3)
+1,instr(empl.present_address,'|',1,4)-instr(empl.present_address,'|',1,3)-1)
present_area_village,
initcap(SUBSTR(empl.present_address,instr(empl.present_address,'|',1,4) +1,instr(empl.present_address,'|',1,5)-instr(empl.present_address,'|',1,4)-1))
present_country,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,5)
+1,instr(empl.present_address,'|',1,6)-instr(empl.present_address,'|',1,5)-1)
present_postal_code,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,6)
+1,instr(empl.present_address,'|',1,7)-instr(empl.present_address,'|',1,6)-1)
present_city,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,7) +1,instr(empl.present_address,'|',1,8)-instr(empl.present_address,'|',1,7)-1)
present_post_office,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,8)
+1,instr(empl.present_address,'|',1,9)-instr(empl.present_address,'|',1,8)-1)
present_police_station,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,9)
+1,instr(empl.present_address,'|',1,10)-instr(empl.present_address,'|',1,9)-1)
present_district,
SUBSTR(empl.present_address,instr(empl.present_address,'|',1,10) +1) present_section
FROM
(SELECT papf.person_id,
papf.employee_number,
initcap(papf.title
||' '
||papf.first_name
||' '
||papf.middle_names
||' '
||papf.last_name) employee_name,
ppt.user_person_type,
pgd.segment1 legal_entity,
pgd.segment2 grade,
SUBSTR(SUBSTR(haou.NAME,instr(haou.NAME,'.')+1),1,instr(SUBSTR(haou.NAME,instr(haou.NAME,'.')+1),'-')-1)
department,
SUBSTR(haou.NAME,instr(haou.NAME,'.')
+1,instr(SUBSTR(haou.NAME,instr(haou.NAME,'.')+1),'.')-1) ORGANIZATION,
SUBSTR(pp.NAME,1,instr(pp.NAME,'|') -1) designation,
hl.location_code work_location,
papf.email_address,
TO_CHAR(ppos.date_start,'DD-Mon-YYYY')
joining_date,
papf.per_information1 mrf_no,
paaf.probation_period,
TO_CHAR(decode(paaf.date_probation_end,'DD-Mon-YYYY',NULL,paaf.date_probation_end,paaf.date_probation_end+1))
date_probation_end,
ROUND((TRUNC(SYSDATE)-ppos.date_start)/365)
job_tenure,
payapf.payroll_name,
(SELECT employee_number
FROM per_all_people_f peop
WHERE peop.person_id= paaf.supervisor_id
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD
HH24:MI:SS') BETWEEN peop.effective_start_date AND peop.effective_end_date
) first_supervisor,
ass_attribute3 second_supervisor,
ass_attribute4 third_supervisor,
paaf.notice_period,
TO_CHAR(papf.date_of_birth,'DD-Mon-YYYY')
dob,
DECODE(papf.sex,'M','Male','Female')
gender,
DECODE(papf.marital_status,'M','Married','Single') marital_status,
papf.blood_type blood_group,
initcap(papf.attribute1) religion,
(SELECT meaning
FROM fnd_lookup_values
WHERE 1 =1
AND lookup_type='NATIONALITY'
AND language ='US'
AND lookup_code=papf.nationality
AND ROWNUM <=1
) nationality,
papf.national_identifier,
papf.attribute3 birth_certificate_num,
ppei.pei_information1 father_name,
ppei.pei_information2 mother_name,
--employee phone details
xxbex_empl_master_rep_pkg.phone2_func(papf.person_id,1)||' '
first_contact,
xxbex_empl_master_rep_pkg.phone2_func(papf.person_id,2)||' '
second_contact,
xxbex_empl_master_rep_pkg.phone2_func(papf.person_id,3)||' '
third_contact,
--employee first
relationship details
xxbex_empl_master_rep_pkg.emp_contact1_func(papf.person_id,1)
first_contact_name,
xxbex_empl_master_rep_pkg.emp_contact2_func(papf.person_id,1)
first_contact_relation,
xxbex_empl_master_rep_pkg.emp_contact3_func(papf.person_id,1)
first_contact_age,
xxbex_empl_master_rep_pkg.emp_contact4_func(papf.person_id,1)
first_contact_address,
xxbex_empl_master_rep_pkg.emp_contact5_func(papf.person_id,1)
first_contact_phone,
xxbex_empl_master_rep_pkg.emp_contact6_func(papf.person_id,1)
first_contact_share,
--employee second
relationship details
xxbex_empl_master_rep_pkg.emp_contact1_func(papf.person_id,2)
second_contact_name,
xxbex_empl_master_rep_pkg.emp_contact2_func(papf.person_id,2)
second_contact_relation,
xxbex_empl_master_rep_pkg.emp_contact3_func(papf.person_id,2)
second_contact_age,
xxbex_empl_master_rep_pkg.emp_contact4_func(papf.person_id,2)
second_contact_address,
xxbex_empl_master_rep_pkg.emp_contact5_func(papf.person_id,2)
second_contact_phone,
xxbex_empl_master_rep_pkg.emp_contact6_func(papf.person_id,2) second_contact_share,
--employee third
relationship details
xxbex_empl_master_rep_pkg.emp_contact1_func(papf.person_id,3)
third_contact_name,
xxbex_empl_master_rep_pkg.emp_contact2_func(papf.person_id,3)
third_contact_relation,
xxbex_empl_master_rep_pkg.emp_contact3_func(papf.person_id,3)
third_contact_age,
xxbex_empl_master_rep_pkg.emp_contact4_func(papf.person_id,3)
third_contact_address,
xxbex_empl_master_rep_pkg.emp_contact5_func(papf.person_id,3)
third_contact_phone,
xxbex_empl_master_rep_pkg.emp_contact6_func(papf.person_id,3)
third_contact_share,
--employee fourth
relationship details
xxbex_empl_master_rep_pkg.emp_contact1_func(papf.person_id,4)
fourth_contact_name,
xxbex_empl_master_rep_pkg.emp_contact2_func(papf.person_id,4)
fourth_contact_relation,
xxbex_empl_master_rep_pkg.emp_contact3_func(papf.person_id,4)
fourth_contact_age,
xxbex_empl_master_rep_pkg.emp_contact4_func(papf.person_id,4)
fourth_contact_address,
xxbex_empl_master_rep_pkg.emp_contact5_func(papf.person_id,4)
fourth_contact_phone,
xxbex_empl_master_rep_pkg.emp_contact6_func(papf.person_id,4)
fourth_contact_share,
--employee address
details
xxbex_empl_master_rep_pkg.emp_address2_func(papf.person_id,1)
permanent_address,
xxbex_empl_master_rep_pkg.emp_address1_func(papf.person_id,1)
present_address,
--employee interview and
written test details
TO_CHAR(to_date(pac.segment1,'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') written_exam_date,
pac.segment2 written_exam_marks,
TO_CHAR(to_date(pac.segment3,'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') first_interview_date ,
pac.segment11 first_interview_remarks,
TO_CHAR(to_date(pac.segment12,'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') second_interview_date,
pac.segment20 second_interview_remarks,
TO_CHAR(to_date(pac.segment21,'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') third_interview_date,
pac.segment29 third_interview_remarks,
--employee first
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,1)
qual_name1,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,1) board1,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,1) result1,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,1)
acad_or_prof1,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,1),'N','No','Y','Yes')
highest_qualn1,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,1)
passing_year1,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,1)
institute1,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,1)
major_sub1,
--employee second
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,2)
qual_name2,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,2) board2,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,2) result2,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,2)
acad_or_prof2,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,2),'N','No','Y','Yes')
highest_qualn2,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,2)
passing_year2,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,2)
institute2,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,2)
major_sub2,
--employee third
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,3)
qual_name3,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,3)
board3,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,3) result3,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,3)
acad_or_prof3,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,3),'N','No','Y','Yes')
highest_qualn3,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,3)
passing_year3,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,3)
institute3,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,3)
major_sub3,
--employee fourth
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,4)
qual_name4,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,4) board4,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,4) result4,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,4)
acad_or_prof4,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,4),'N','No','Y','Yes')
highest_qualn4,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,4)
passing_year4,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,4)
institute4,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,4)
major_sub4,
--employee fifth
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,5)
qual_name5,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,5) board5,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,5) result5,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,5)
acad_or_prof5,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,5),'N','No','Y','Yes')
highest_qualn5,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,5)
passing_year5,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,5)
institute5,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,5)
major_sub5,
--employee sixth
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,6)
qual_name6,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,6) board6,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,6)
result6,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,6)
acad_or_prof6,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,6),'N','No','Y','Yes')
highest_qualn6,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,6)
passing_year6,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,6)
institute6,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,6)
major_sub6,
--employee seventh
qualification details
xxbex_empl_master_rep_pkg.qualification1_func(papf.person_id,7)
qual_name7,
xxbex_empl_master_rep_pkg.qualification2_func(papf.person_id,7) board7,
xxbex_empl_master_rep_pkg.qualification3_func(papf.person_id,7) result7,
xxbex_empl_master_rep_pkg.qualification4_func(papf.person_id,7)
acad_or_prof7,
decode(xxbex_empl_master_rep_pkg.qualification5_func(papf.person_id,7),'N','No','Y','Yes')
highest_qualn7,
xxbex_empl_master_rep_pkg.qualification6_func(papf.person_id,7)
passing_year7,
xxbex_empl_master_rep_pkg.qualification7_func(papf.person_id,7)
institute7,
xxbex_empl_master_rep_pkg.qualification8_func(papf.person_id,7)
major_sub7,
--employee first
passport details
xxbex_empl_master_rep_pkg.passport1_func(papf.person_id,1)
passport_num1,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.passport2_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') issue_date1,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.passport3_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') expiry_date1,
xxbex_empl_master_rep_pkg.passport4_func(papf.person_id,1) country1,
--employee second
qualification details
xxbex_empl_master_rep_pkg.passport1_func(papf.person_id,2)
passport_num2,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.passport2_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') issue_date2,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.passport3_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') expiry_date2,
xxbex_empl_master_rep_pkg.passport4_func(papf.person_id,2) country2,
--employee first
training details
xxbex_empl_master_rep_pkg.training1_func(papf.person_id,1)
training_title1,
xxbex_empl_master_rep_pkg.training2_func(papf.person_id,1)
training_type1,
xxbex_empl_master_rep_pkg.training3_func(papf.person_id,1)
training_loc1,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.training4_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') training_date_from1,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.training5_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') training_date_to1,
xxbex_empl_master_rep_pkg.training6_func(papf.person_id,1)
training_institute1,
xxbex_empl_master_rep_pkg.training7_func(papf.person_id,1)
training_hours1,
xxbex_empl_master_rep_pkg.training8_func(papf.person_id,1)
training_cost1,
--employee second
training details
xxbex_empl_master_rep_pkg.training1_func(papf.person_id,2)
training_title2,
xxbex_empl_master_rep_pkg.training2_func(papf.person_id,2)
training_type2,
xxbex_empl_master_rep_pkg.training3_func(papf.person_id,2)
training_loc2,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.training4_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') training_date_from2,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.training5_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') training_date_to2,
xxbex_empl_master_rep_pkg.training6_func(papf.person_id,2)
training_institute2,
xxbex_empl_master_rep_pkg.training7_func(papf.person_id,2)
training_hours2,
xxbex_empl_master_rep_pkg.training8_func(papf.person_id,2)
training_cost2,
--employee third
training details
xxbex_empl_master_rep_pkg.training1_func(papf.person_id,3)
training_title3,
xxbex_empl_master_rep_pkg.training2_func(papf.person_id,3)
training_type3,
xxbex_empl_master_rep_pkg.training3_func(papf.person_id,3)
training_loc3,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.training4_func(papf.person_id,3),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') training_date_from3,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.training5_func(papf.person_id,3),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') training_date_to3,
xxbex_empl_master_rep_pkg.training6_func(papf.person_id,3)
training_institute3,
xxbex_empl_master_rep_pkg.training7_func(papf.person_id,3)
training_hours3,
xxbex_empl_master_rep_pkg.training8_func(papf.person_id,3)
training_cost3,
--employee first
overseas trip details
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.overseas_details1_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') travel_date_from1,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.overseas_details2_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') travel_date_to1,
xxbex_empl_master_rep_pkg.overseas_details3_func(papf.person_id,1)
travel_duration1,
xxbex_empl_master_rep_pkg.overseas_details4_func(papf.person_id,1)
travel_country1,
xxbex_empl_master_rep_pkg.overseas_details5_func(papf.person_id,1)
travel_purpose1,
xxbex_empl_master_rep_pkg.overseas_details6_func(papf.person_id,1)
travel_cost1,
xxbex_empl_master_rep_pkg.overseas_details7_func(papf.person_id,1)
company_cost1,
xxbex_empl_master_rep_pkg.overseas_details8_func(papf.person_id,1)
external_cost1,
xxbex_empl_master_rep_pkg.overseas_details9_func(papf.person_id,1)
external_body1,
--employee second
overseas trip details
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.overseas_details1_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') travel_date_from2,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.overseas_details2_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') travel_date_to2,
xxbex_empl_master_rep_pkg.overseas_details3_func(papf.person_id,2)
travel_duration2,
xxbex_empl_master_rep_pkg.overseas_details4_func(papf.person_id,2)
travel_country2,
xxbex_empl_master_rep_pkg.overseas_details5_func(papf.person_id,2)
travel_purpose2,
xxbex_empl_master_rep_pkg.overseas_details6_func(papf.person_id,2)
travel_cost2,
xxbex_empl_master_rep_pkg.overseas_details7_func(papf.person_id,2)
company_cost2,
xxbex_empl_master_rep_pkg.overseas_details8_func(papf.person_id,2)
external_cost2,
xxbex_empl_master_rep_pkg.overseas_details9_func(papf.person_id,2)
external_body2,
--employee third
overseas trip details
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.overseas_details1_func(papf.person_id,3),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') travel_date_from3,
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.overseas_details2_func(papf.person_id,3),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') travel_date_to3,
xxbex_empl_master_rep_pkg.overseas_details3_func(papf.person_id,3)
travel_duration3,
xxbex_empl_master_rep_pkg.overseas_details4_func(papf.person_id,3)
travel_country3,
xxbex_empl_master_rep_pkg.overseas_details5_func(papf.person_id,3)
travel_purpose3,
xxbex_empl_master_rep_pkg.overseas_details6_func(papf.person_id,3)
travel_cost3,
xxbex_empl_master_rep_pkg.overseas_details7_func(papf.person_id,3)
company_cost3,
xxbex_empl_master_rep_pkg.overseas_details8_func(papf.person_id,3)
external_cost3,
xxbex_empl_master_rep_pkg.overseas_details9_func(papf.person_id,3)
external_body3,
--employee first
disciplinary issue details
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.diciplinary1_func(papf.person_id,1),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') incident_date1,
xxbex_empl_master_rep_pkg.diciplinary4_func(papf.person_id,1) outcome1,
--employee second
disciplinary issue details
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.diciplinary1_func(papf.person_id,2),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') incident_date2,
xxbex_empl_master_rep_pkg.diciplinary4_func(papf.person_id,2) outcome2,
--employee third
disciplinary issue details
TO_CHAR(to_date(xxbex_empl_master_rep_pkg.diciplinary1_func(papf.person_id,3),'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') incident_date3,
xxbex_empl_master_rep_pkg.diciplinary4_func(papf.person_id,3) outcome3,
ppev.employer_name ,
TO_CHAR(ppev.start_date,'DD-Mon-YYYY')
prev_start_date,
TO_CHAR(ppev.end_date,'DD-Mon-YYYY')
prev_end_date,
TO_CHAR(ppos.actual_termination_date,'DD-Mon-YYYY') separation_date,
/*added for Leaving reason meaning*/
(Select flv.meaning
from fnd_lookup_values flv
where flv.lookup_code =ppos.leaving_reason
AND flv.lookup_type = 'LEAV_REAS')
leaving_reason
/*till here*/
FROM per_all_people_f papf,
per_person_types ppt,
per_all_assignments_f paaf,
per_grades pg,
per_grade_definitions pgd,
per_positions pp,
hr_all_organization_units haou,
hr_locations hl,
per_periods_of_service ppos,
pay_all_payrolls_f payapf,
per_people_extra_info ppei,
per_person_analyses ppa,
per_analysis_criteria pac,
fnd_id_flex_structures_vl fifs,
per_person_type_usages_f pptf,
per_previous_employers_v ppev
WHERE 1 =1
--- AND papf.person_type_id =ppt.person_type_id
AND papf.person_id =paaf.person_id
AND paaf.grade_id = pg.grade_id(+)
AND pg.grade_definition_id = pgd.grade_definition_id(+)
AND paaf.position_id = pp.position_id(+)
AND paaf.organization_id = haou.organization_id(+)
AND paaf.location_id = hl.location_id(+)
AND papf.person_id = ppos.person_id
AND paaf.period_of_service_id = ppos.period_of_service_id
AND paaf.payroll_id = payapf.payroll_id(+)
AND paaf.primary_flag ='Y'
AND papf.person_id = ppei.person_id(+)
AND ppei.information_type(+) = 'BEX_EMP_PARENTS'
AND papf.person_id = ppa.person_id(+)
AND ppa.analysis_criteria_id = pac.analysis_criteria_id(+)
AND ppa.date_to(+) IS NULL
AND pac.id_flex_num = fifs.id_flex_num(+)
AND fifs.id_flex_structure_code(+)='Interview
and Written Results'
AND papf.person_id = ppev.person_id(+)
AND papf.person_id =
NVL(:P_PERSON_ID,papf.person_id)
AND NVL(substr(pp.name,instr(pp.name,'|',1,2)+1),'N') =
NVL(:P_ORGANIZATION_ID,NVL(substr(pp.name,instr(pp.name,'|',1,2)+1),'N'))
AND NVL(pgd.segment2,'N') =
NVL(:P_GRADE_ID,NVL(pgd.segment2,'N'))
AND NVL(hl.location_code,'N') =
NVL(:P_LOCATION_ID,NVL(hl.location_code,'N'))
AND ppt.person_type_id =
NVL(:P_PERSON_TYPE_ID,ppt.person_type_id)
and papf.person_id = pptf.person_id
AND PPTF.person_type_id = ppt.person_type_id
AND NVL(pgd.segment1,'N') =
NVL(:P_LEGAL_ENTITY,NVL(pgd.segment1,'N'))
--- and papf.employee_number in (
'14050','1027','900011')
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD
HH24:MI:SS') BETWEEN papf.effective_start_date AND papf.effective_end_date
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD
HH24:MI:SS') BETWEEN pptf.effective_start_date AND pptf.effective_end_date
/*added for including Ex-Employees*/
AND ( (ppt.user_person_type LIKE
'Ex-employee%'
AND
PPOS.ACTUAL_TERMINATION_DATE BETWEEN paaf.effective_start_date
AND PAAF.EFFECTIVE_END_DATE)
OR (ppt.SYSTEM_person_type LIKE 'EMP%'
AND
to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD HH24:MI:SS') BETWEEN
paaf.effective_start_date
AND PAAF.EFFECTIVE_END_DATE) )
/*till here*/
) empl
order by empl.employee_number
]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_EMPL"
dataType="varchar2" source="Q_EMPL">
<element name="PERSON_ID" dataType="varchar2"
value="PERSON_ID"/>
<element
name="EMPLOYEE_NUMBER" dataType="varchar2"
value="EMPLOYEE_NUMBER"/>
<element
name="EMPLOYEE_NAME" dataType="varchar2"
value="EMPLOYEE_NAME"/>
<element name="USER_PERSON_TYPE"
dataType="varchar2" value="USER_PERSON_TYPE"/>
<element
name="LEGAL_ENTITY" dataType="varchar2"
value="LEGAL_ENTITY"/>
<element
name="GRADE" dataType="varchar2"
value="GRADE"/>
<element
name="DEPARTMENT" dataType="varchar2" value="DEPARTMENT"/>
<element
name="ORGANIZATION" dataType="varchar2"
value="ORGANIZATION"/>
<element
name="DESIGNATION" dataType="varchar2"
value="DESIGNATION"/>
<element
name="WORK_LOCATION" dataType="varchar2"
value="WORK_LOCATION" />
<element
name="EMAIL_ADDRESS" dataType="varchar2"
value="EMAIL_ADDRESS" />
<element
name="JOINING_DATE" dataType="varchar2"
value="JOINING_DATE"/>
<element
name="MRF_NO" dataType="varchar2"
value="MRF_NO"/>
<element
name="PROBATION_PERIOD" dataType="varchar2"
value="PROBATION_PERIOD"/>
<element
name="DATE_PROBATION_END" dataType="varchar2"
value="DATE_PROBATION_END"/>
<element
name="JOB_TENURE" dataType="varchar2"
value="JOB_TENURE"/>
<element
name="PAYROLL_NAME" dataType="varchar2" value="PAYROLL_NAME"/>
<element
name="FIRST_SUPERVISOR" dataType="varchar2"
value="FIRST_SUPERVISOR"/>
<element
name="SECOND_SUPERVISOR" dataType="varchar2"
value="SECOND_SUPERVISOR"/>
<element
name="THIRD_SUPERVISOR" dataType="varchar2"
value="THIRD_SUPERVISOR"/>
<element
name="NOTICE_PERIOD" dataType="varchar2"
value="NOTICE_PERIOD"/>
<element
name="DOB" dataType="varchar2" value="DOB"/>
<element
name="GENDER" dataType="varchar2"
value="GENDER"/>
<element
name="MARITAL_STATUS" dataType="varchar2"
value="MARITAL_STATUS"/>
<element
name="BLOOD_GROUP" dataType="varchar2"
value="BLOOD_GROUP"/>
<element
name="RELIGION" dataType="varchar2"
value="RELIGION"/>
<element
name="NATIONALITY" dataType="varchar2"
value="NATIONALITY"/>
<element
name="NATIONAL_IDENTIFIER" dataType="varchar2"
value="NATIONAL_IDENTIFIER"/>
<element
name="BIRTH_CERTIFICATE_NUM" dataType="varchar2"
value="BIRTH_CERTIFICATE_NUM"/>
<element
name="FATHER_NAME" dataType="varchar2"
value="FATHER_NAME"/>
<element
name="MOTHER_NAME" dataType="varchar2"
value="MOTHER_NAME"/>
<element
name="FIRST_CONTACT" dataType="varchar2"
value="FIRST_CONTACT" />
<element
name="SECOND_CONTACT" dataType="varchar2" value="SECOND_CONTACT"
/>
<element
name="THIRD_CONTACT" dataType="varchar2"
value="THIRD_CONTACT"/>
<element
name="FIRST_CONTACT_NAME" dataType="varchar2"
value="FIRST_CONTACT_NAME"/>
<element
name="FIRST_CONTACT_RELATION" dataType="varchar2" value="FIRST_CONTACT_RELATION"/>
<element
name="FIRST_CONTACT_AGE" dataType="varchar2"
value="FIRST_CONTACT_AGE"/>
<element
name="FIRST_CONTACT_ADDRESS" dataType="varchar2"
value="FIRST_CONTACT_ADDRESS"/>
<element
name="FIRST_CONTACT_PHONE" dataType="varchar2"
value="FIRST_CONTACT_PHONE"/>
<element
name="FIRST_CONTACT_SHARE" dataType="varchar2"
value="FIRST_CONTACT_SHARE"/>
<element
name="SECOND_CONTACT_NAME" dataType="varchar2"
value="SECOND_CONTACT_NAME"/>
<element
name="SECOND_CONTACT_RELATION" dataType="varchar2"
value="SECOND_CONTACT_RELATION"/>
<element
name="SECOND_CONTACT_AGE" dataType="varchar2"
value="SECOND_CONTACT_AGE"/>
<element
name="SECOND_CONTACT_ADDRESS" dataType="varchar2"
value="SECOND_CONTACT_ADDRESS"/>
<element
name="SECOND_CONTACT_PHONE" dataType="varchar2"
value="SECOND_CONTACT_PHONE"/>
<element
name="SECOND_CONTACT_SHARE" dataType="varchar2"
value="SECOND_CONTACT_SHARE"/>
<element
name="THIRD_CONTACT_NAME" dataType="varchar2"
value="THIRD_CONTACT_NAME"/>
<element
name="THIRD_CONTACT_RELATION" dataType="varchar2"
value="THIRD_CONTACT_RELATION"/>
<element
name="THIRD_CONTACT_AGE" dataType="varchar2"
value="THIRD_CONTACT_AGE"/>
<element
name="THIRD_CONTACT_ADDRESS" dataType="varchar2" value="THIRD_CONTACT_ADDRESS"/>
<element
name="THIRD_CONTACT_PHONE" dataType="varchar2"
value="THIRD_CONTACT_PHONE"/>
<element
name="THIRD_CONTACT_SHARE" dataType="varchar2"
value="THIRD_CONTACT_SHARE"/>
<element
name="FOURTH_CONTACT_NAME" dataType="varchar2"
value="FOURTH_CONTACT_NAME"/>
<element
name="FOURTH_CONTACT_RELATION" dataType="varchar2"
value="FOURTH_CONTACT_RELATION"/>
<element
name="FOURTH_CONTACT_AGE" dataType="varchar2"
value="FOURTH_CONTACT_AGE"/>
<element
name="FOURTH_CONTACT_ADDRESS" dataType="varchar2"
value="FOURTH_CONTACT_ADDRESS"/>
<element
name="FOURTH_CONTACT_PHONE" dataType="varchar2"
value="FOURTH_CONTACT_PHONE"/>
<element
name="FOURTH_CONTACT_SHARE" dataType="varchar2"
value="FOURTH_CONTACT_SHARE"/>
<element
name="WRITTEN_EXAM_DATE" dataType="varchar2"
value="WRITTEN_EXAM_DATE"/>
<element
name="WRITTEN_EXAM_MARKS" dataType="varchar2"
value="WRITTEN_EXAM_MARKS" />
<element
name="FIRST_INTERVIEW_DATE" dataType="varchar2"
value="FIRST_INTERVIEW_DATE" />
<element
name="FIRST_INTERVIEW_REMARKS" dataType="varchar2"
value="FIRST_INTERVIEW_REMARKS"/>
<element
name="SECOND_INTERVIEW_DATE" dataType="varchar2"
value="SECOND_INTERVIEW_DATE"/>
<element
name="SECOND_INTERVIEW_REMARKS" dataType="varchar2"
value="SECOND_INTERVIEW_REMARKS"/>
<element
name="THIRD_INTERVIEW_DATE" dataType="varchar2"
value="THIRD_INTERVIEW_DATE"/>
<element
name="THIRD_INTERVIEW_REMARKS" dataType="varchar2"
value="THIRD_INTERVIEW_REMARKS"/>
<element
name="QUAL_NAME1" dataType="varchar2"
value="QUAL_NAME1"/>
<element
name="BOARD1" dataType="varchar2"
value="BOARD1"/>
<element
name="RESULT1" dataType="varchar2"
value="RESULT1"/>
<element name="ACAD_OR_PROF1"
dataType="varchar2" value="ACAD_OR_PROF1"/>
<element
name="HIGHEST_QUALN1" dataType="varchar2"
value="HIGHEST_QUALN1"/>
<element
name="PASSING_YEAR1" dataType="varchar2"
value="PASSING_YEAR1"/>
<element
name="INSTITUTE1" dataType="varchar2"
value="INSTITUTE1"/>
<element
name="MAJOR_SUB1" dataType="varchar2"
value="MAJOR_SUB1"/>
<element
name="QUAL_NAME2" dataType="varchar2"
value="QUAL_NAME2"/>
<element
name="BOARD2" dataType="varchar2"
value="BOARD2"/>
<element name="RESULT2"
dataType="varchar2" value="RESULT2"/>
<element
name="ACAD_OR_PROF2" dataType="varchar2"
value="ACAD_OR_PROF2"/>
<element
name="HIGHEST_QUALN2" dataType="varchar2"
value="HIGHEST_QUALN2"/>
<element
name="PASSING_YEAR2" dataType="varchar2" value="PASSING_YEAR2"/>
<element
name="INSTITUTE2" dataType="varchar2"
value="INSTITUTE2"/>
<element
name="MAJOR_SUB2" dataType="varchar2"
value="MAJOR_SUB2"/>
<element
name="QUAL_NAME3" dataType="varchar2"
value="QUAL_NAME3"/>
<element
name="BOARD3" dataType="varchar2"
value="BOARD3"/>
<element
name="RESULT3" dataType="varchar2"
value="RESULT3"/>
<element
name="ACAD_OR_PROF3" dataType="varchar2"
value="ACAD_OR_PROF3" />
<element
name="HIGHEST_QUALN3" dataType="varchar2"
value="HIGHEST_QUALN3" />
<element
name="PASSING_YEAR3" dataType="varchar2"
value="PASSING_YEAR3"/>
<element
name="INSTITUTE3" dataType="varchar2"
value="INSTITUTE3"/>
<element
name="MAJOR_SUB3" dataType="varchar2"
value="MAJOR_SUB3"/>
<element
name="QUAL_NAME4" dataType="varchar2"
value="QUAL_NAME4"/>
<element
name="BOARD4" dataType="varchar2"
value="BOARD4"/>
<element
name="RESULT4" dataType="varchar2"
value="RESULT4"/>
<element
name="ACAD_OR_PROF4" dataType="varchar2"
value="ACAD_OR_PROF4"/>
<element
name="HIGHEST_QUALN4" dataType="varchar2"
value="HIGHEST_QUALN4"/>
<element
name="PASSING_YEAR4" dataType="varchar2"
value="PASSING_YEAR4"/>
<element
name="INSTITUTE4" dataType="varchar2"
value="INSTITUTE4"/>
<element
name="MAJOR_SUB4" dataType="varchar2"
value="MAJOR_SUB4"/>
<element
name="QUAL_NAME5" dataType="varchar2"
value="QUAL_NAME5"/>
<element
name="BOARD5" dataType="varchar2"
value="BOARD5"/>
<element
name="RESULT5" dataType="varchar2" value="RESULT5"/>
<element
name="ACAD_OR_PROF5" dataType="varchar2"
value="ACAD_OR_PROF5"/>
<element
name="HIGHEST_QUALN5" dataType="varchar2"
value="HIGHEST_QUALN5"/>
<element
name="PASSING_YEAR5" dataType="varchar2"
value="PASSING_YEAR5"/>
<element
name="INSTITUTE5" dataType="varchar2"
value="INSTITUTE5"/>
<element
name="MAJOR_SUB5" dataType="varchar2"
value="MAJOR_SUB5"/>
<element
name="QUAL_NAME6" dataType="varchar2"
value="QUAL_NAME6"/>
<element
name="BOARD6" dataType="varchar2"
value="BOARD6"/>
<element
name="RESULT6" dataType="varchar2"
value="RESULT6"/>
<element
name="ACAD_OR_PROF6" dataType="varchar2"
value="ACAD_OR_PROF6"/>
<element
name="HIGHEST_QUALN6" dataType="varchar2"
value="HIGHEST_QUALN6"/>
<element
name="PASSING_YEAR6" dataType="varchar2"
value="PASSING_YEAR6" />
<element
name="INSTITUTE6" dataType="varchar2"
value="INSTITUTE6" />
<element
name="MAJOR_SUB6" dataType="varchar2"
value="MAJOR_SUB6"/>
<element
name="QUAL_NAME7" dataType="varchar2"
value="QUAL_NAME7"/>
<element
name="BOARD7" dataType="varchar2"
value="BOARD7"/>
<element
name="RESULT7" dataType="varchar2"
value="RESULT7"/>
<element
name="ACAD_OR_PROF7" dataType="varchar2"
value="ACAD_OR_PROF7"/>
<element
name="HIGHEST_QUALN7" dataType="varchar2"
value="HIGHEST_QUALN7"/>
<element
name="PASSING_YEAR7" dataType="varchar2"
value="PASSING_YEAR7"/>
<element
name="INSTITUTE7" dataType="varchar2"
value="INSTITUTE7"/>
<element
name="MAJOR_SUB7" dataType="varchar2"
value="MAJOR_SUB7"/>
<element
name="PASSPORT_NUM1" dataType="varchar2"
value="PASSPORT_NUM1"/>
<element
name="ISSUE_DATE1" dataType="varchar2"
value="ISSUE_DATE1"/>
<element
name="EXPIRY_DATE1" dataType="varchar2" value="EXPIRY_DATE1"/>
<element
name="COUNTRY1" dataType="varchar2"
value="COUNTRY1"/>
<element
name="PASSPORT_NUM2" dataType="varchar2"
value="PASSPORT_NUM2"/>
<element
name="ISSUE_DATE2" dataType="varchar2"
value="ISSUE_DATE2"/>
<element name="EXPIRY_DATE2"
dataType="varchar2" value="EXPIRY_DATE2"/>
<element
name="COUNTRY2" dataType="varchar2"
value="COUNTRY2"/>
<element
name="TRAINING_TITLE1" dataType="varchar2"
value="TRAINING_TITLE1"/>
<element
name="TRAINING_TYPE1" dataType="varchar2" value="TRAINING_TYPE1"/>
<element
name="TRAINING_LOC1" dataType="varchar2"
value="TRAINING_LOC1"/>
<element
name="TRAINING_DATE_FROM1" dataType="varchar2"
value="TRAINING_DATE_FROM1"/>
<element
name="TRAINING_DATE_TO1" dataType="varchar2" value="TRAINING_DATE_TO1"
/>
<element
name="TRAINING_INSTITUTE1" dataType="varchar2"
value="TRAINING_INSTITUTE1" />
<element
name="TRAINING_HOURS1" dataType="varchar2"
value="TRAINING_HOURS1"/>
<element
name="TRAINING_COST1" dataType="varchar2" value="TRAINING_COST1"/>
<element
name="TRAINING_TITLE2" dataType="varchar2"
value="TRAINING_TITLE2"/>
<element
name="TRAINING_TYPE2" dataType="varchar2"
value="TRAINING_TYPE2"/>
<element
name="TRAINING_LOC2" dataType="varchar2"
value="TRAINING_LOC2"/>
<element
name="TRAINING_DATE_FROM2" dataType="varchar2"
value="TRAINING_DATE_FROM2"/>
<element
name="TRAINING_DATE_TO2" dataType="varchar2"
value="TRAINING_DATE_TO2"/>
<element
name="TRAINING_INSTITUTE2" dataType="varchar2"
value="TRAINING_INSTITUTE2"/>
<element
name="TRAINING_HOURS2" dataType="varchar2"
value="TRAINING_HOURS2"/>
<element
name="TRAINING_COST2" dataType="varchar2"
value="TRAINING_COST2"/>
<element
name="TRAINING_TITLE3" dataType="varchar2"
value="TRAINING_TITLE3"/>
<element
name="TRAINING_TYPE3" dataType="varchar2"
value="TRAINING_TYPE3"/>
<element
name="TRAINING_LOC3" dataType="varchar2"
value="TRAINING_LOC3"/>
<element name="TRAINING_DATE_FROM3"
dataType="varchar2" value="TRAINING_DATE_FROM3"/>
<element
name="TRAINING_DATE_TO3" dataType="varchar2"
value="TRAINING_DATE_TO3"/>
<element
name="TRAINING_INSTITUTE3" dataType="varchar2"
value="TRAINING_INSTITUTE3"/>
<element
name="TRAINING_HOURS3" dataType="varchar2"
value="TRAINING_HOURS3"/>
<element
name="TRAINING_COST3" dataType="varchar2"
value="TRAINING_COST3"/>
<element
name="TRAVEL_DATE_FROM1" dataType="varchar2"
value="TRAVEL_DATE_FROM1"/>
<element name="TRAVEL_DATE_TO1"
dataType="varchar2" value="TRAVEL_DATE_TO1"/>
<element
name="TRAVEL_DURATION1" dataType="varchar2"
value="TRAVEL_DURATION1"/>
<element
name="TRAVEL_COUNTRY1" dataType="varchar2"
value="TRAVEL_COUNTRY1"/>
<element
name="TRAVEL_PURPOSE1" dataType="varchar2"
value="TRAVEL_PURPOSE1"/>
<element
name="TRAVEL_COST1" dataType="varchar2"
value="TRAVEL_COST1"/>
<element
name="COMPANY_COST1" dataType="varchar2"
value="COMPANY_COST1" />
<element
name="EXTERNAL_COST1" dataType="varchar2"
value="EXTERNAL_COST1" />
<element
name="EXTERNAL_BODY1" dataType="varchar2"
value="EXTERNAL_BODY1"/>
<element
name="TRAVEL_DATE_FROM2" dataType="varchar2"
value="TRAVEL_DATE_FROM2"/>
<element
name="TRAVEL_DATE_TO2" dataType="varchar2"
value="TRAVEL_DATE_TO2"/>
<element
name="TRAVEL_DURATION2" dataType="varchar2"
value="TRAVEL_DURATION2"/>
<element
name="TRAVEL_COUNTRY2" dataType="varchar2"
value="TRAVEL_COUNTRY2"/>
<element
name="TRAVEL_PURPOSE2" dataType="varchar2" value="TRAVEL_PURPOSE2"/>
<element
name="TRAVEL_COST2" dataType="varchar2"
value="TRAVEL_COST2"/>
<element
name="COMPANY_COST2" dataType="varchar2"
value="COMPANY_COST2"/>
<element
name="EXTERNAL_COST2" dataType="varchar2"
value="EXTERNAL_COST2"/>
<element
name="EXTERNAL_BODY2" dataType="varchar2"
value="EXTERNAL_BODY2"/>
<element
name="TRAVEL_DATE_FROM3" dataType="varchar2"
value="TRAVEL_DATE_FROM3"/>
<element
name="TRAVEL_DATE_TO3" dataType="varchar2"
value="TRAVEL_DATE_TO3"/>
<element
name="TRAVEL_DURATION3" dataType="varchar2"
value="TRAVEL_DURATION3"/>
<element
name="TRAVEL_COUNTRY3" dataType="varchar2"
value="TRAVEL_COUNTRY3"/>
<element
name="TRAVEL_PURPOSE3" dataType="varchar2"
value="TRAVEL_PURPOSE3"/>
<element name="TRAVEL_COST3"
dataType="varchar2" value="TRAVEL_COST3"/>
<element
name="COMPANY_COST3" dataType="varchar2"
value="COMPANY_COST3"/>
<element
name="EXTERNAL_COST3" dataType="varchar2"
value="EXTERNAL_COST3"/>
<element
name="EXTERNAL_BODY3" dataType="varchar2"
value="EXTERNAL_BODY3"/>
<element
name="INCIDENT_DATE1" dataType="varchar2"
value="INCIDENT_DATE1" />
<element
name="OUTCOME1" dataType="varchar2"
value="OUTCOME1" />
<element
name="INCIDENT_DATE2" dataType="varchar2" value="INCIDENT_DATE2"/>
<element
name="OUTCOME2" dataType="varchar2"
value="OUTCOME2"/>
<element
name="INCIDENT_DATE3" dataType="varchar2"
value="INCIDENT_DATE3"/>
<element
name="OUTCOME3" dataType="varchar2"
value="OUTCOME3"/>
<element name="EMPLOYER_NAME"
dataType="varchar2" value="EMPLOYER_NAME"/>
<element
name="PREV_START_DATE" dataType="varchar2"
value="PREV_START_DATE"/>
<element
name="PREV_END_DATE" dataType="varchar2"
value="PREV_END_DATE"/>
<element
name="SEPARATION_DATE" dataType="varchar2"
value="SEPARATION_DATE"/>
<element
name="LEAVING_REASON" dataType="varchar2"
value="LEAVING_REASON"/>
<element
name="PERM_FLAT_NO" dataType="varchar2"
value="PERM_FLAT_NO"/>
<element
name="PERM_BLOCK_ROAD_NO" dataType="varchar2" value="PERM_BLOCK_ROAD_NO"/>
<element
name="PERM_AREA_VILLAGE" dataType="varchar2"
value="PERM_AREA_VILLAGE"/>
<element
name="PERM_COUNTRY" dataType="varchar2"
value="PERM_COUNTRY"/>
<element
name="PERM_POSTAL_CODE" dataType="varchar2" value="PERM_POSTAL_CODE"/>
<element
name="PERM_CITY" dataType="varchar2"
value="PERM_CITY"/>
<element
name="PERM_POST_OFFICE" dataType="varchar2"
value="PERM_POST_OFFICE" />
<element
name="PERM_POLICE_STATION" dataType="varchar2"
value="PERM_POLICE_STATION" />
<element
name="PERM_DISTRICT" dataType="varchar2"
value="PERM_DISTRICT"/>
<element
name="PERM_SECTION" dataType="varchar2"
value="PERM_SECTION"/>
<element
name="PRESENT_FLAT_NO" dataType="varchar2"
value="PRESENT_FLAT_NO"/>
<element
name="PRESENT_BLOCK_ROAD_NO" dataType="varchar2"
value="PRESENT_BLOCK_ROAD_NO"/>
<element
name="PRESENT_AREA_VILLAGE" dataType="varchar2"
value="PRESENT_AREA_VILLAGE"/>
<element
name="PRESENT_COUNTRY" dataType="varchar2"
value="PRESENT_COUNTRY"/>
<element
name="PRESENT_POSTAL_CODE" dataType="varchar2"
value="PRESENT_POSTAL_CODE"/>
<element
name="PRESENT_CITY" dataType="varchar2"
value="PRESENT_CITY"/>
<element
name="PRESENT_POST_OFFICE" dataType="varchar2"
value="PRESENT_POST_OFFICE"/>
<element
name="PRESENT_POLICE_STATION" dataType="varchar2"
value="PRESENT_POLICE_STATION"/>
<element
name="PRESENT_DISTRICT" dataType="varchar2"
value="PRESENT_DISTRICT"/>
<element
name="PRESENT_SECTION" dataType="varchar2"
value="PRESENT_SECTION"/>
</group>
</dataStructure>
</dataTemplate>
I have an Oracle task that I need help with. Could you please contact me via lamikayty@yahoo.com Its urgent.
ReplyDelete