APPS.PER_NL_LTSRR_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 758: , per_all_assignments_f paa

754: , pab.absence_attendance_id abs_att_id
755: FROM per_absence_attendance_types paat
756: , per_absence_attendances pab
757: , pay_payroll_actions ppa
758: , per_all_assignments_f paa
759: , per_all_people_f pap
760: WHERE paat.absence_category = 'S'
761: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
762: AND paat.business_group_id = pab.business_group_id

Line 793: , per_all_assignments_f paa

789: FROM per_absence_attendance_types paat
790: , per_absence_attendances pab
791: , pay_payroll_actions ppa
792: , per_org_structure_versions posv
793: , per_all_assignments_f paa
794: , per_all_people_f pap
795: WHERE posv.organization_structure_id = p_org_struct_id
796: AND posv.date_from <= p_end_date
797: AND nvl (posv.date_to, hr_general.end_of_time) >= p_start_date

Line 846: , per_all_assignments_f paa

842: paa.assignment_id assignment_id
843: , pab.absence_attendance_id abs_att_id
844: FROM per_absence_attendance_types paat
845: , per_absence_attendances pab
846: , per_all_assignments_f paa
847: , per_all_people_f pap
848: , pay_payroll_actions ppa
849: , per_org_structure_versions posv
850: WHERE posv.organization_structure_id = p_org_struct_id

Line 899: , per_all_assignments_f paa

895: SELECT DISTINCT
896: paa.assignment_id assignment_id
897: FROM pay_action_information pai
898: , pay_payroll_actions ppa
899: , per_all_assignments_f paa
900: , per_all_people_f pap
901: WHERE pai.action_context_type = 'AAP'
902: AND pai.action_information_category = 'NL_LTSRR_ABS_INFO'
903: AND pai.action_information4 = 'LTSRR'

Line 941: , per_all_assignments_f paa

937: paa.assignment_id assignment_id
938: FROM pay_action_information pai
939: , pay_payroll_actions ppa
940: , per_org_structure_versions posv
941: , per_all_assignments_f paa
942: , per_all_people_f pap
943: WHERE posv.organization_structure_id = p_org_struct_id
944: AND posv.date_from <= p_end_date
945: AND nvl (posv.date_to

Line 1000: , per_all_assignments_f paa

996: ,p_type IN VARCHAR2) IS
997: SELECT DISTINCT
998: paa.assignment_id assignment_id
999: FROM pay_action_information pai
1000: , per_all_assignments_f paa
1001: , per_all_people_f pap
1002: , pay_payroll_actions ppa
1003: , per_org_structure_versions posv
1004: WHERE posv.organization_structure_id = p_org_struct_id

Line 1174: FROM per_all_assignments_f pas

1170: ,p_abs_start_date IN DATE) IS
1171: SELECT hou.organization_id org_id
1172: , hou.name org_name
1173: , hoi.org_information4 tax_reg
1174: FROM per_all_assignments_f pas
1175: , hr_organization_units hou
1176: , hr_organization_information hoi
1177: , per_org_structure_versions posv
1178: WHERE posv.organization_structure_id = p_org_struct_id

Line 1192: FROM per_all_assignments_f pas

1188: CURSOR csr_get_leg_info(p_assignment_id IN NUMBER) IS
1189: SELECT hou.organization_id org_id
1190: , hou.name org_name
1191: , hoi.org_information1 tax_reg
1192: FROM per_all_assignments_f pas
1193: , hr_organization_units hou
1194: , hr_organization_information hoi
1195: WHERE pas.assignment_id = p_assignment_id
1196: AND hou.organization_id = pas.establishment_id

Line 1220: , per_all_assignments_f pas

1216: , pab.abs_information_category info_cat
1217: FROM per_absence_attendance_types paat
1218: , per_absence_attendances pab
1219: , pay_assignment_actions paa
1220: , per_all_assignments_f pas
1221: WHERE paat.absence_category = 'S'
1222: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1223: AND paat.business_group_id = pab.business_group_id
1224: AND (pab.date_end + 1) BETWEEN p_start_date

Line 1249: FROM per_all_assignments_f pas

1245: ,hoi.org_information6 contact_per_or_dept
1246: ,hoi.org_information7 est_name
1247: ,hoi.org_information8 gender_contact
1248: ,hoi.org_information9 ph_no_contact
1249: FROM per_all_assignments_f pas
1250: ,hr_organization_units hou
1251: ,hr_organization_information hoi
1252: WHERE pas.assignment_id = p_assignment_id
1253: AND p_start_date BETWEEN pas.effective_start_date

Line 1278: ,per_all_assignments_f pas

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

Line 1295: FROM per_all_assignments_f pas

1291: SELECT pei_information21 contact_name
1292: ,pei_information22 est_name
1293: ,pei_information23 gender
1294: ,pei_information24 contact_ph_no
1295: FROM per_all_assignments_f pas
1296: ,per_people_extra_info pei
1297: WHERE pas.assignment_id = p_assignment_id
1298: AND p_start_date BETWEEN pas.effective_start_date
1299: AND pas.effective_end_date

Line 1391: FROM per_all_assignments_f pas

1387: SELECT to_char(min (pas.effective_start_date),'YYYYMMDD') ass_start_date
1388: ,to_char(decode (max (pas.effective_end_date)
1389: ,hr_general.end_of_time
1390: ,to_date(NULL),max (pas.effective_end_date)),'YYYYMMDD') ass_end_date
1391: FROM per_all_assignments_f pas
1392: WHERE pas.assignment_id = p_assignment_id;
1393: /**************************************************************************/
1394: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1395: SELECT paei.aei_information1 numiv_override