[Home] [Help]
79: p_end_person_id in per_all_people_f.person_id%type,
80: p_chunk in number )
81: is
82:
83: l_next_action_id pay_assignment_actions.assignment_action_id%type;
84: --
85: ------------------------------------------------------------------------
86: --Bug#3833818 Added payroll_id join to improve performance of the query.
87: --Bug #14654315, added condition if multi CSN exists
90: is
91: select distinct paa.assignment_id
92: from pay_payroll_actions xppa,
93: pay_payroll_actions rppa,
94: pay_assignment_actions rpac,
95: per_assignments_f paa,
96: per_assignment_extra_info aei1,
97: per_assignment_extra_info aei2,
98: hr_organization_information hoi
127: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'));
128: --
129: cursor next_action_id
130: is
131: select pay_assignment_actions_s.nextval
132: from dual;
133: --
134: begin
135: l_package := ' pay_sg_cpfline.';
217: ------------------------------------------------------------
218: -- Archive Code
219: ------------------------------------------------------------
220: procedure archive_code
221: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
222: p_effective_date in date)
223: is
224: --
225: l_assignment_id per_all_assignments_f.assignment_id%type;
230: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
231: g_context_tab pay_balance_pkg.t_context_tab;
232: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
233: --
234: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
235: l_action_info_id pay_action_information.action_information_id%type;
236: l_ovn pay_action_information.object_version_number%type;
237: l_person_id per_all_people_f.person_id%type;
238: l_fwl_amt number;
245: -- Bug# 4226037 Included period_of_service_id join to fetch correct
246: -- actual_termination_date of an assignment.
247: ---------------------------------------------------------------------------
248: cursor csr_employee_details
249: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type )
250: is
251: select substr(pap.per_information1,1,22),
252: substr(pap.employee_number,1,15),
253: fnd_date.date_to_canonical(pps.actual_termination_date),
261: pap.person_id,
262: fnd_date.date_to_canonical(paa.effective_start_date),
263: nvl(aei1.aei_information1,hoi.org_information10),
264: aei2.aei_information1
265: from pay_assignment_actions pac,
266: pay_payroll_actions rppa,
267: pay_assignment_actions rpac,
268: per_assignments_f paa,
269: per_assignment_extra_info aei1,
263: nvl(aei1.aei_information1,hoi.org_information10),
264: aei2.aei_information1
265: from pay_assignment_actions pac,
266: pay_payroll_actions rppa,
267: pay_assignment_actions rpac,
268: per_assignments_f paa,
269: per_assignment_extra_info aei1,
270: per_assignment_extra_info aei2,
271: per_people_f pap,
516: --
517: if retain_archive_flag = 'N' then
518: delete from pay_action_information
519: where action_context_id in ( select assignment_action_id
520: from pay_assignment_actions
521: where payroll_action_id = p_payroll_action_id )
522: and action_information_category = 'SG CPF DETAILS'
523: and action_context_type = 'AAC';
524: end if ;