APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on PER_ALL_ASSIGNMENTS_F

Line 321: , per_all_assignments_f as1

317: IS
318: SELECT '1'
319: FROM pay_payroll_actions appa
320: , pay_assignment_actions act
321: , per_all_assignments_f as1
322: , pay_payroll_actions ppa
323: WHERE ppa.payroll_action_id = p_payroll_action_id
324: AND appa.effective_date BETWEEN csr_v_canonical_start_date
325: AND csr_v_canonical_end_date

Line 545: , per_all_assignments_f as1

541: , pay_payroll_actions appa2
542: , pay_assignment_actions act
543: , pay_assignment_actions act1
544: , pay_action_interlocks pai
545: , per_all_assignments_f as1
546: WHERE ppa.payroll_action_id = p_payroll_action_id
547: AND appa.effective_date BETWEEN l_canonical_start_date
548: AND l_canonical_end_date
549: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 575: , per_all_assignments_f as1

571: SELECT as1.person_id person_id, act.assignment_id assignment_id
572: , act.assignment_action_id run_action_id
573: FROM pay_payroll_actions appa
574: , pay_assignment_actions act
575: , per_all_assignments_f as1
576: , pay_payroll_actions ppa
577: WHERE ppa.payroll_action_id = p_payroll_action_id
578: AND appa.effective_date BETWEEN l_canonical_start_date
579: AND l_canonical_end_date

Line 945: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

941: l_eit_local_unit NUMBER;
942: l_legal_employer_id_fetched NUMBER;
943: -- Temp needed Variables
944: l_person_id per_all_people_f.person_id%TYPE;
945: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
946:
947: -- Temp needed Variables
948:
949: -- End of place for Variables which fetches the values to be archived

Line 963: , per_all_assignments_f paa

959: SELECT pap.last_name, pap.pre_name_adjunct, pap.first_name
960: , pap.national_identifier, pap.person_id, pac.assignment_id
961: , paa.assignment_number, paa.employee_category
962: FROM pay_assignment_actions pac
963: , per_all_assignments_f paa
964: , per_all_people_f pap
965: WHERE pac.assignment_action_id = p_asg_act_id
966: AND paa.assignment_id = pac.assignment_id
967: AND paa.person_id = pap.person_id

Line 980: FROM per_all_assignments_f paa

976: -- Cursor to pick up segment2
977: CURSOR csr_get_segment2
978: IS
979: SELECT scl.segment2, scl.segment8
980: FROM per_all_assignments_f paa
981: , hr_soft_coding_keyflex scl
982: , pay_assignment_actions pasa
983: WHERE pasa.assignment_action_id = p_assignment_action_id
984: AND pasa.assignment_id = paa.assignment_id