[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;
210: p_chunk in number )
211: is
212: v_next_action_id pay_assignment_actions.assignment_action_id%type;
213: v_person_id per_all_people_f.person_id%type;
214: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
215: v_business_group_id number;
216: v_basis_start date;
217: v_basis_end date;
218: v_legal_entity_id number;
246: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
247: c_start_person_id in per_all_people_f.person_id%type,
248: c_end_person_id in per_all_people_f.person_id%type,
249: c_person_id in per_all_people_f.person_id%type,
250: c_assignment_set_id in hr_assignment_sets.assignment_set_id%type,
251: c_business_group_id in number,
252: c_legal_entity_id in number,
253: c_basis_start in date,
254: c_basis_end in date) is
260: and ppa1.business_group_id = paf.business_group_id
261: and paf.person_id = nvl(c_person_id,paf.person_id)
262: and paf.assignment_type = 'E' /* Bug 5033609 */
263: and decode(c_assignment_set_id,null,'Y',
264: decode(hr_assignment_set.ASSIGNMENT_IN_SET(c_assignment_set_id,paf.assignment_id),'Y','Y','N')) = 'Y'
265: and exists
266: ( select null
267: from pay_payroll_actions ppa,
268: pay_assignment_actions paa