[Home] [Help]
9: g_basis_start date;
10: g_basis_year varchar2(4);
11: g_legal_entity_id varchar2(20);
12: g_person_id per_all_people_f.person_id%type;
13: g_assignment_set_id hr_assignment_sets.assignment_set_id%type;
14: g_setup_action_id pay_payroll_actions.payroll_action_id%type;
15: g_report_type varchar2(30);
16: g_previous_person_id per_all_people_f.person_id%type;
17: g_moa_369_date ff_archive_items.value%type;
213: p_chunk in number )
214: is
215: v_next_action_id pay_assignment_actions.assignment_action_id%type;
216: v_person_id per_all_people_f.person_id%type;
217: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
218: v_business_group_id number;
219: v_basis_start date;
220: v_basis_end date;
221: v_legal_entity_id number;
249: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
250: c_start_person_id in per_all_people_f.person_id%type,
251: c_end_person_id in per_all_people_f.person_id%type,
252: c_person_id in per_all_people_f.person_id%type,
253: c_assignment_set_id in hr_assignment_sets.assignment_set_id%type,
254: c_business_group_id in number,
255: c_legal_entity_id in number,
256: c_basis_start in date,
257: c_basis_end in date) is
263: and ppa1.business_group_id = paf.business_group_id
264: and paf.person_id = nvl(c_person_id,paf.person_id)
265: and paf.assignment_type = 'E' /* Bug 5033609 */
266: and decode(c_assignment_set_id,null,'Y',
267: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,paf.assignment_id),'Y','Y','N')) = 'Y'
268: and exists
269: ( select null
270: from pay_payroll_actions ppa,
271: pay_assignment_actions paa