[Home] [Help]
5: PROCEDURE range_cursor (pactid IN NUMBER,
6: sqlstr OUT nocopy VARCHAR2);
7: --
8: procedure assignment_action_code
9: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
10: p_start_person_id in per_all_people_f.person_id%type,
11: p_end_person_id in per_all_people_f.person_id%type,
12: p_chunk in number);
13: --
53: ,'PAYROLL_ID=C'
54: ,ppa.payroll_id
55: ,'PAYROLL_ACTION_ID=C'
56: ,ppa.payroll_action_id
57: FROM pay_payroll_actions ppa
58: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
59: --
60: CURSOR CSR_KW_PIFSS_BODY IS
61: SELECT /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
91: ,'ORGANIZATION_ID=C' , asg.organization_id
92: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
93: FROM per_assignments_f asg
94: ,pay_assignment_actions paa
95: ,pay_payroll_actions ppa
96: ,hr_soft_coding_keyflex hscl
97: ,per_people_f pef
98: ,pay_payroll_actions ppa1
99: ,pay_legislation_rules leg
94: ,pay_assignment_actions paa
95: ,pay_payroll_actions ppa
96: ,hr_soft_coding_keyflex hscl
97: ,per_people_f pef
98: ,pay_payroll_actions ppa1
99: ,pay_legislation_rules leg
100: WHERE asg.assignment_id = paa.assignment_id
101: AND pef.person_id = asg.person_id
102: AND paa.payroll_action_id = ppa.payroll_action_id
154: ,'ORGANIZATION_ID=C' , asg.organization_id
155: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
156: FROM per_assignments_f asg
157: ,pay_assignment_actions paa
158: ,pay_payroll_actions ppa
159: ,hr_soft_coding_keyflex hscl
160: ,per_people_f pef
161: ,pay_payroll_actions ppa1
162: ,pay_legislation_rules leg
157: ,pay_assignment_actions paa
158: ,pay_payroll_actions ppa
159: ,hr_soft_coding_keyflex hscl
160: ,per_people_f pef
161: ,pay_payroll_actions ppa1
162: ,pay_legislation_rules leg
163: WHERE asg.assignment_id = paa.assignment_id
164: AND pef.person_id = asg.person_id
165: AND paa.payroll_action_id = ppa.payroll_action_id