[Home] [Help]
264: )
265: IS
266: SELECT '1'
267: FROM pay_payroll_actions appa
268: ,pay_assignment_actions act
269: ,per_all_assignments_f as1
270: ,pay_payroll_actions ppa
271: WHERE ppa.payroll_action_id = p_payroll_action_id
272: AND appa.effective_date BETWEEN csr_v_canonical_start_date
463: SELECT as1.person_id person_id
464: ,act.assignment_id assignment_id
465: ,act.assignment_action_id run_action_id
466: FROM pay_payroll_actions appa
467: ,pay_assignment_actions act
468: ,per_all_assignments_f as1
469: ,pay_payroll_actions ppa
470: WHERE ppa.payroll_action_id = p_payroll_action_id
471: AND appa.effective_date BETWEEN l_canonical_start_date
577: )
578: LOOP
579: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
580: THEN
581: SELECT pay_assignment_actions_s.NEXTVAL
582: INTO l_actid
583: FROM DUAL;
584:
585: -- Create the archive assignment action
1009: /* Cursor to retrieve Person Details */
1010: CURSOR csr_get_assignment_id (p_asg_act_id NUMBER)
1011: IS
1012: SELECT pac.assignment_id
1013: FROM pay_assignment_actions pac
1014: WHERE pac.assignment_action_id = p_asg_act_id;
1015:
1016: CURSOR csr_get_person_details (p_asg_act_id NUMBER)
1017: IS
1023: ,pac.assignment_id
1024: ,paa.assignment_number
1025: ,paa.employee_category
1026: ,paa.effective_start_date
1027: FROM pay_assignment_actions pac
1028: ,per_all_assignments_f paa
1029: ,per_all_people_f pap
1030: WHERE pac.assignment_action_id = p_asg_act_id
1031: AND paa.assignment_id = pac.assignment_id
1044: SELECT scl.segment2
1045: ,scl.segment8
1046: FROM per_all_assignments_f paa
1047: ,hr_soft_coding_keyflex scl
1048: ,pay_assignment_actions pasa
1049: WHERE pasa.assignment_action_id = p_assignment_action_id
1050: AND pasa.assignment_id = paa.assignment_id
1051: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
1052: -- AND paa.primary_flag = 'Y'