APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 320: , pay_assignment_actions act

316: )
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

Line 542: , pay_assignment_actions act

538: , act1.assignment_action_id prepaid_action_id
539: FROM pay_payroll_actions ppa
540: , pay_payroll_actions appa
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

Line 543: , pay_assignment_actions act1

539: FROM pay_payroll_actions ppa
540: , pay_payroll_actions appa
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

Line 574: , pay_assignment_actions act

570: */
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

Line 688: SELECT pay_assignment_actions_s.NEXTVAL

684: LOOP
685: --fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');
686: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
687: THEN
688: SELECT pay_assignment_actions_s.NEXTVAL
689: INTO l_actid
690: FROM DUAL;
691:
692: -- Create the archive assignment action

Line 962: FROM pay_assignment_actions pac

958: IS
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

Line 982: , pay_assignment_actions pasa

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
985: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
986: AND paa.primary_flag = 'Y'