APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 298: from hr_assignment_set_amendments asgset,

294: elsif ln_asg_set is not null then
295:
296: lv_sql_string :=
297: 'select distinct paf.person_id
298: from hr_assignment_set_amendments asgset,
299: per_assignments_f paf
300: where assignment_set_id = ' || ln_asg_set || '
301: and asgset.assignment_id = paf.assignment_id
302: and asgset.include_or_exclude = ''I''

Line 422: from hr_assignment_set_amendments asgset,

418: ,cp_end_person in number
419: ,cp_asg_set in number
420: ,cp_effective_date in date) is
421: select distinct paf.person_id
422: from hr_assignment_set_amendments asgset,
423: per_assignments_f paf,
424: pay_payroll_actions ppa,
425: pay_assignment_actions paa
426: where asgset.assignment_set_id = cp_asg_set

Line 445: from hr_assignment_set_amendments asgset,

441: ,cp_end_person in number
442: ,cp_asg_set in number
443: ,cp_effective_date in date) is
444: select distinct paf.person_id
445: from hr_assignment_set_amendments asgset,
446: per_assignments_f paf,
447: pay_payroll_actions ppa,
448: pay_assignment_actions paa,
449: pay_population_ranges ppr

Line 1388: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

1384: l_sort3 varchar2(60);
1385: l_year_start date;
1386: l_year_end date;
1387: l_print varchar2(20);
1388: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1389: l_bg_id pay_payroll_actions.business_group_id%type ;
1390:
1391: begin
1392: