APPS.PAY_FI_ARCHIVE_UMFR dependencies on PER_ALL_ASSIGNMENTS_F

Line 610: ,per_all_assignments_f as1

606: ,pay_payroll_actions appa2
607: ,pay_assignment_actions act
608: ,pay_assignment_actions act1
609: ,pay_action_interlocks pai
610: ,per_all_assignments_f as1
611: ,hr_soft_coding_keyflex hsck
612: ,pay_run_result_values TARGET
613: ,pay_run_results RR
614: ,pay_element_entries_f PEEF

Line 678: ,per_all_assignments_f as1

674: ,pay_payroll_actions appa2
675: ,pay_assignment_actions act
676: ,pay_assignment_actions act1
677: ,pay_action_interlocks pai
678: ,per_all_assignments_f as1
679: ,hr_soft_coding_keyflex hsck
680: ,pay_run_result_values TARGET
681: ,pay_run_results RR
682: ,pay_element_entries_f PEEF

Line 748: ,per_all_assignments_f as1

744: ,pay_payroll_actions appa2
745: ,pay_assignment_actions act
746: ,pay_assignment_actions act1
747: ,pay_action_interlocks pai
748: ,per_all_assignments_f as1
749: ,hr_soft_coding_keyflex hsck
750: ,pay_run_result_values TARGET
751: ,pay_run_results RR
752: ,pay_element_entries_f PEEF

Line 1279: per_all_assignments_f paa,

1275: paa.assignment_id assignment_id,
1276: pap.per_information18 membership_start_date,
1277: pap.per_information19 membership_end_date
1278: FROM per_all_people_f pap,
1279: per_all_assignments_f paa,
1280: hr_soft_coding_keyflex scl,
1281: pay_assignment_actions pasa
1282: WHERE paa.person_id = pap.person_id
1283: AND pasa.assignment_id = paa.assignment_id

Line 1320: FROM per_all_assignments_f paa,

1316: -- Cursor to pick up segment2
1317: CURSOR csr_get_segment2
1318: IS
1319: SELECT scl.segment2
1320: FROM per_all_assignments_f paa,
1321: hr_soft_coding_keyflex scl,
1322: pay_assignment_actions pasa
1323: WHERE pasa.assignment_action_id = p_assignment_action_id
1324: AND pasa.assignment_id = paa.assignment_id