[Home] [Help]
304: )
305: IS
306: SELECT '1'
307: FROM pay_payroll_actions appa
308: ,pay_assignment_actions act
309: ,per_all_assignments_f as1
310: ,pay_payroll_actions ppa
311: WHERE ppa.payroll_action_id = p_payroll_action_id
312: AND appa.effective_date BETWEEN csr_v_canonical_start_date
503: SELECT as1.person_id person_id
504: ,act.assignment_id assignment_id
505: ,act.assignment_action_id run_action_id
506: FROM pay_payroll_actions appa
507: ,pay_assignment_actions act
508: ,per_all_assignments_f as1
509: ,pay_payroll_actions ppa
510: WHERE ppa.payroll_action_id = p_payroll_action_id
511: AND appa.effective_date BETWEEN l_canonical_start_date
617: )
618: LOOP
619: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
620: THEN
621: SELECT pay_assignment_actions_s.NEXTVAL
622: INTO l_actid
623: FROM DUAL;
624:
625: -- Create the archive assignment action
1056: /* Cursor to retrieve Person Details */
1057: CURSOR csr_get_assignment_id (p_asg_act_id NUMBER)
1058: IS
1059: SELECT pac.assignment_id
1060: FROM pay_assignment_actions pac
1061: WHERE pac.assignment_action_id = p_asg_act_id;
1062:
1063: CURSOR csr_get_person_details (p_asg_act_id NUMBER)
1064: IS
1070: ,pac.assignment_id
1071: ,paa.assignment_number
1072: ,paa.employee_category
1073: ,paa.effective_start_date
1074: FROM pay_assignment_actions pac
1075: ,per_all_assignments_f paa
1076: ,per_all_people_f pap
1077: WHERE pac.assignment_action_id = p_asg_act_id
1078: AND paa.assignment_id = pac.assignment_id
1091: SELECT scl.segment2
1092: ,scl.segment8
1093: FROM per_all_assignments_f paa
1094: ,hr_soft_coding_keyflex scl
1095: ,pay_assignment_actions pasa
1096: WHERE pasa.assignment_action_id = p_assignment_action_id
1097: AND pasa.assignment_id = paa.assignment_id
1098: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
1099: -- AND paa.primary_flag = 'Y'