DBA Data[Home] [Help]

APPS.PAY_US_W2C_ARCH dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 254: from hr_assignment_set_amendments asgset,

250: elsif ln_asg_set is not null then
251:
252: lv_sql_string :=
253: 'select distinct paf.person_id
254: from hr_assignment_set_amendments asgset,
255: per_all_assignments_f paf
256: where assignment_set_id = ''' || ln_asg_set || '''
257: and asgset.assignment_id = paf.assignment_id
258: and asgset.include_or_exclude = ''I''

Line 333: from hr_assignment_set_amendments asgset,

329: ,cp_asg_set in number
330: ,cp_eoy_pactid in number
331: ,cp_year_start_date in date) is
332: select distinct paf.person_id
333: from hr_assignment_set_amendments asgset,
334: per_all_assignments_f paf
335: where assignment_set_id = cp_asg_set
336: and asgset.include_or_exclude = 'I'
337: and paf.assignment_id = asgset.assignment_id