APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 190: from hr_assignment_set_amendments asgset,

186: elsif ln_asg_set is not null then
187:
188: lv_sql_string :=
189: 'select distinct paf.person_id
190: from hr_assignment_set_amendments asgset,
191: per_assignments_f paf
192: where assignment_set_id = ' || ln_asg_set || '
193: and asgset.assignment_id = paf.assignment_id
194: and asgset.include_or_exclude = ''I''

Line 297: from hr_assignment_set_amendments asgset,

293: ,cp_end_person in number
294: ,cp_asg_set in number
295: ,cp_effective_date in date) is
296: select distinct paf.person_id
297: from hr_assignment_set_amendments asgset,
298: per_assignments_f paf,
299: pay_payroll_actions ppa_arch,
300: pay_assignment_actions paa_arch
301: where asgset.assignment_set_id = cp_asg_set