DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 315: from hr_assignment_set_amendments asgset,

311: elsif ln_asg_set is not null then
312:
313: lv_sql_string :=
314: 'select distinct paf.person_id
315: from hr_assignment_set_amendments asgset,
316: per_assignments_f paf
317: where assignment_set_id = ' || ln_asg_set || '
318: and asgset.assignment_id = paf.assignment_id
319: 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_arch,
431: pay_assignment_actions paa_arch
432: where asgset.assignment_set_id = cp_asg_set

Line 455: from hr_assignment_set_amendments asgset,

451: ,cp_end_person in number
452: ,cp_asg_set in number
453: ,cp_effective_date in date) is
454: select distinct paf.person_id
455: from hr_assignment_set_amendments asgset,
456: per_assignments_f paf,
457: pay_payroll_actions ppa_arch,
458: pay_assignment_actions paa_arch,
459: pay_population_ranges ppr