APPS.PAY_SG_CPFLINE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 82: l_next_action_id pay_assignment_actions.assignment_action_id%type;

78: p_end_person_id in per_all_people_f.person_id%type,
79: p_chunk in number )
80: is
81:
82: l_next_action_id pay_assignment_actions.assignment_action_id%type;
83: --
84: ------------------------------------------------------------------------
85: --Bug#3833818 Added payroll_id join to improve performance of the query.
86: ------------------------------------------------------------------------

Line 92: pay_assignment_actions rpac,

88: is
89: select distinct paa.assignment_id
90: from pay_payroll_actions xppa,
91: pay_payroll_actions rppa,
92: pay_assignment_actions rpac,
93: per_assignments_f paa
94: where xppa.payroll_action_id = p_payroll_action_id
95: and paa.person_id between p_start_person_id
96: and p_end_person_id

Line 113: select pay_assignment_actions_s.nextval

109: and paa.effective_end_date ;
110: --
111: cursor next_action_id
112: is
113: select pay_assignment_actions_s.nextval
114: from dual;
115: --
116: begin
117: l_package := ' pay_sg_cpfline.';

Line 202: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

198: ------------------------------------------------------------
199: -- Archive Code
200: ------------------------------------------------------------
201: procedure archive_code
202: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
203: p_effective_date in date)
204: is
205: --
206: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 215: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

211: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
212: g_context_tab pay_balance_pkg.t_context_tab;
213: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
214: --
215: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
216: l_action_info_id pay_action_information.action_information_id%type;
217: l_ovn pay_action_information.object_version_number%type;
218: l_person_id per_all_people_f.person_id%type;
219: l_fwl_amt number;

Line 230: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type )

226: -- Bug# 4226037 Included period_of_service_id join to fetch correct
227: -- actual_termination_date of an assignment.
228: ---------------------------------------------------------------------------
229: cursor csr_employee_details
230: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type )
231: is
232: select substr(pap.per_information1,1,22),
233: substr(pap.employee_number,1,15),
234: fnd_date.date_to_canonical(pps.actual_termination_date),

Line 244: from pay_assignment_actions pac,

240: nvl(pap.per_information14,pap.national_identifier),
241: fnd_date.date_to_canonical(pps.date_start),
242: pap.person_id,
243: fnd_date.date_to_canonical(paa.effective_start_date)
244: from pay_assignment_actions pac,
245: pay_payroll_actions rppa,
246: pay_assignment_actions rpac,
247: per_assignments_f paa,
248: per_people_f pap,

Line 246: pay_assignment_actions rpac,

242: pap.person_id,
243: fnd_date.date_to_canonical(paa.effective_start_date)
244: from pay_assignment_actions pac,
245: pay_payroll_actions rppa,
246: pay_assignment_actions rpac,
247: per_assignments_f paa,
248: per_people_f pap,
249: per_periods_of_service pps,
250: hr_organization_units hou

Line 464: from pay_assignment_actions

460: --
461: if retain_archive_flag = 'N' then
462: delete from pay_action_information
463: where action_context_id in ( select assignment_action_id
464: from pay_assignment_actions
465: where payroll_action_id = p_payroll_action_id )
466: and action_information_category = 'SG CPF DETAILS'
467: and action_context_type = 'AAC';
468: end if ;