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.PER_NL_LTSR_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 327: FROM per_all_assignments_f paa

323: ,c_person_id IN NUMBER
324: ,c_start_date IN DATE
325: ,c_end_date IN DATE) IS
326: SELECT 1
327: FROM per_all_assignments_f paa
328: ,per_assignment_status_types past
329: ,per_all_people_f pap
330: ,per_org_structure_versions posv
331: ,per_absence_attendances pab

Line 375: FROM per_all_assignments_f paa

371: ,c_person_id IN NUMBER
372: ,c_start_date IN DATE
373: ,c_end_date IN DATE) IS
374: SELECT 1
375: FROM per_all_assignments_f paa
376: ,per_all_people_f pap
377: ,per_org_structure_versions posv
378: ,per_absence_attendances pab
379: ,per_absence_attendance_types paat

Line 753: ,per_all_assignments_f paa

749: paa.assignment_id assignment_id
750: FROM per_absence_attendance_types paat
751: ,per_absence_attendances pab
752: ,pay_payroll_actions ppa
753: ,per_all_assignments_f paa
754: ,per_all_people_f pap
755: WHERE paat.absence_category = 'S'
756: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
757: AND paat.business_group_id = pab.business_group_id

Line 787: ,per_all_assignments_f paa

783: FROM per_absence_attendance_types paat
784: ,per_absence_attendances pab
785: ,pay_payroll_actions ppa
786: ,per_org_structure_versions posv
787: ,per_all_assignments_f paa
788: ,per_all_people_f pap
789: WHERE posv.organization_structure_id = p_org_struct_id
790: AND posv.date_from <= p_end_date
791: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date

Line 839: ,per_all_assignments_f paa

835: SELECT DISTINCT
836: paa.assignment_id assignment_id
837: FROM per_absence_attendance_types paat
838: ,per_absence_attendances pab
839: ,per_all_assignments_f paa
840: ,per_all_people_f pap
841: ,pay_payroll_actions ppa
842: ,per_org_structure_versions posv
843: WHERE posv.organization_structure_id = p_org_struct_id

Line 891: ,per_all_assignments_f paa

887: SELECT DISTINCT
888: paa.assignment_id assignment_id
889: FROM pay_action_information pai
890: ,pay_payroll_actions ppa
891: ,per_all_assignments_f paa
892: ,per_all_people_f pap
893: WHERE pai.action_context_type = 'AAP'
894: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
895: AND pai.action_information4 = 'LTSR'

Line 933: ,per_all_assignments_f paa

929: paa.assignment_id assignment_id
930: FROM pay_action_information pai
931: ,pay_payroll_actions ppa
932: ,per_org_structure_versions posv
933: ,per_all_assignments_f paa
934: ,per_all_people_f pap
935: WHERE posv.organization_structure_id = p_org_struct_id
936: AND posv.date_from <= p_end_date
937: AND nvl (posv.date_to

Line 992: ,per_all_assignments_f paa

988: ,p_type IN VARCHAR2) IS
989: SELECT DISTINCT
990: paa.assignment_id assignment_id
991: FROM pay_action_information pai
992: ,per_all_assignments_f paa
993: ,per_all_people_f pap
994: ,pay_payroll_actions ppa
995: ,per_org_structure_versions posv
996: WHERE posv.organization_structure_id = p_org_struct_id

Line 1166: FROM per_all_assignments_f pas

1162: , p_abs_start_date IN DATE) IS
1163: SELECT hou.organization_id org_id
1164: ,hou.name org_name
1165: ,hoi.org_information4 tax_reg
1166: FROM per_all_assignments_f pas
1167: ,hr_organization_units hou
1168: ,hr_organization_information hoi
1169: ,per_org_structure_versions posv
1170: WHERE posv.organization_structure_id = p_org_struct_id

Line 1184: FROM per_all_assignments_f pas

1180: CURSOR csr_get_leg_info(p_assignment_id IN NUMBER) IS
1181: SELECT hou.organization_id org_id
1182: ,hou.name org_name
1183: ,hoi.org_information1 tax_reg
1184: FROM per_all_assignments_f pas
1185: ,hr_organization_units hou
1186: ,hr_organization_information hoi
1187: WHERE pas.assignment_id = p_assignment_id
1188: AND hou.organization_id = pas.establishment_id

Line 1213: , per_all_assignments_f pas

1209: , pab.abs_information_category info_cat
1210: FROM per_absence_attendance_types paat
1211: , per_absence_attendances pab
1212: , pay_assignment_actions paa
1213: , per_all_assignments_f pas
1214: WHERE paat.absence_category = 'S'
1215: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1216: AND paat.business_group_id = pab.business_group_id
1217: AND pab.date_start BETWEEN p_start_date

Line 1253: FROM per_all_assignments_f pas

1249: ,hoi.org_information6 contact_per_or_dept
1250: ,hoi.org_information7 est_name
1251: ,hoi.org_information8 gender_contact
1252: ,hoi.org_information9 ph_no_contact
1253: FROM per_all_assignments_f pas
1254: ,hr_organization_units hou
1255: ,hr_organization_information hoi
1256: WHERE pas.assignment_id = p_assignment_id
1257: AND p_start_date BETWEEN pas.effective_start_date

Line 1280: ,per_all_assignments_f pas

1276: ,pap.business_group_id bg_id
1277: ,pas.establishment_id establishment_id
1278: ,pas.assignment_sequence asg_seq
1279: FROM per_all_people_f pap
1280: ,per_all_assignments_f pas
1281: WHERE pas.assignment_id = p_assignment_id
1282: AND p_start_date BETWEEN pas.effective_start_date
1283: AND pas.effective_end_date
1284: AND pap.person_id = pas.person_id

Line 1322: FROM per_all_assignments_f pas

1318: ,pei_information22 est_name
1319: ,pei_information23 gender
1320: ,pei_information24 contact_ph_no
1321: -- ,pei_information3 l29bzw
1322: FROM per_all_assignments_f pas
1323: ,per_people_extra_info pei
1324: WHERE pas.assignment_id = p_assignment_id
1325: AND p_start_date BETWEEN pas.effective_start_date
1326: AND pas.effective_end_date