APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 176: from hr_assignment_set_amendments asgset,

172: elsif ln_asg_set is not null then
173:
174: lv_sql_string :=
175: 'select distinct paf.person_id
176: from hr_assignment_set_amendments asgset,
177: per_assignments_f paf
178: where assignment_set_id = ' || ln_asg_set || '
179: and asgset.assignment_id = paf.assignment_id
180: and asgset.include_or_exclude = ''I''

Line 281: from hr_assignment_set_amendments asgset,

277: ,cp_end_person in number
278: ,cp_asg_set in number
279: ,cp_effective_date in date) is
280: select distinct paf.person_id
281: from hr_assignment_set_amendments asgset,
282: per_assignments_f paf,
283: pay_payroll_actions ppa_arch,
284: pay_assignment_actions paa_arch
285: where asgset.assignment_set_id = cp_asg_set