APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 303: from hr_assignment_set_amendments asgset,

299: elsif ln_asg_set is not null then
300:
301: lv_sql_string :=
302: 'select distinct paf.person_id
303: from hr_assignment_set_amendments asgset,
304: per_assignments_f paf
305: where assignment_set_id = ' || ln_asg_set || '
306: and asgset.assignment_id = paf.assignment_id
307: and asgset.include_or_exclude = ''I''

Line 428: from hr_assignment_set_amendments asgset,

424: ,cp_end_person in number
425: ,cp_asg_set in number
426: ,cp_effective_date in date) is
427: select distinct paf.person_id
428: from hr_assignment_set_amendments asgset,
429: per_assignments_f paf,
430: pay_payroll_actions ppa,
431: pay_assignment_actions paa
432: where asgset.assignment_set_id = cp_asg_set

Line 451: from hr_assignment_set_amendments asgset,

447: ,cp_end_person in number
448: ,cp_asg_set in number
449: ,cp_effective_date in date) is
450: select distinct paf.person_id
451: from hr_assignment_set_amendments asgset,
452: per_assignments_f paf,
453: pay_payroll_actions ppa,
454: pay_assignment_actions paa,
455: pay_population_ranges ppr

Line 1437: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

1433: l_sort3 varchar2(60);
1434: l_year_start date;
1435: l_year_end date;
1436: l_print varchar2(20);
1437: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1438: l_bg_id pay_payroll_actions.business_group_id%type ;
1439:
1440: begin
1441: