eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_IZA_UPLOAD dependencies on PER_ALL_PEOPLE_F

Line 137: per_all_people_f pap

133: ,pap.LAST_NAME last_name
134: ,pap.date_of_birth
135: ,pap.per_information15
136: FROM
137: per_all_people_f pap
138: ,per_all_assignments_f paa
139: WHERE pap.business_group_id = v_business_group_id
140: and pap.person_id = v_person_id
141: and pap.person_id = paa.person_id

Line 163: per_all_people_f pap

159: ) IS
160: SELECT
161: pap.person_id person_id
162: FROM
163: per_all_people_f pap
164: ,per_all_assignments_f paa
165: ,PER_ASSIGNMENT_EXTRA_INFO pae_iza
166: ,PER_ASSIGNMENT_EXTRA_INFO pae_sii
167: WHERE pap.business_group_id = v_business_group_id

Line 920: from per_all_people_f pap

916:
917:
918: cursor csr_employee_terminate(v_person_id number,v_bg_id number,v_period_start_date date,v_period_end_date date) IS
919: select pap.effective_start_date - 1
920: from per_all_people_f pap
921: where PER_INFORMATION_CATEGORY='NL'
922: and pap.business_group_id = v_bg_id
923: and pap.person_id = v_person_id
924: and pap.current_employee_flag is null

Line 1399: from per_all_people_f pap

1395:
1396:
1397: cursor csr_contract_other_cmpny(v_person_id number,v_bg_id number,v_period_start_date date,v_period_end_date date) IS
1398: select pap.per_information16
1399: from per_all_people_f pap
1400: where PER_INFORMATION_CATEGORY='NL'
1401: and pap.business_group_id = v_bg_id
1402: and pap.person_id = v_person_id
1403: and pap.per_information16 = 'Y'

Line 1410: FROM per_all_people_f pap

1406:
1407:
1408: cursor csr_emp_num_exists(v_employee_num varchar2,v_bg_id number,v_period_start_date date,v_period_end_date date) IS
1409: SELECT pap.person_id,paa.assignment_id,paa.assignment_number
1410: FROM per_all_people_f pap
1411: ,per_all_assignments_f paa
1412: WHERE ltrim(substr(pap.employee_number,1,9),'0') = v_employee_num
1413: AND paa.person_id = pap.person_id
1414: AND pap.business_group_id = v_bg_id

Line 1422: from per_all_people_f pap

1418:
1419:
1420: cursor csr_employee_exists(v_person_id number,v_bg_id number,v_period_start_date date,v_period_end_date date) IS
1421: select pap.current_employee_flag
1422: from per_all_people_f pap
1423: where PER_INFORMATION_CATEGORY='NL'
1424: and pap.business_group_id = v_bg_id
1425: and pap.person_id = v_person_id
1426: and pap.current_employee_flag = 'Y'