DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 327: from hr_assignment_set_amendments asgset,

323: elsif ln_asg_set is not null then
324:
325: lv_sql_string :=
326: 'select distinct paf.person_id
327: from hr_assignment_set_amendments asgset,
328: per_assignments_f paf
329: where assignment_set_id = ' || ln_asg_set || '
330: and asgset.assignment_id = paf.assignment_id
331: and asgset.include_or_exclude = ''I''

Line 442: from hr_assignment_set_amendments asgset,

438: ,cp_end_person in number
439: ,cp_asg_set in number
440: ,cp_effective_date in date) is
441: select distinct paf.person_id
442: from hr_assignment_set_amendments asgset,
443: per_assignments_f paf,
444: pay_payroll_actions ppa,
445: pay_assignment_actions paa
446: where asgset.assignment_set_id = cp_asg_set

Line 467: from hr_assignment_set_amendments asgset,

463: ,cp_end_person in number
464: ,cp_asg_set in number
465: ,cp_effective_date in date) is
466: select distinct paf.person_id
467: from hr_assignment_set_amendments asgset,
468: per_assignments_f paf,
469: pay_payroll_actions ppa,
470: pay_assignment_actions paa,
471: pay_population_ranges ppr