DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 314: from hr_assignment_set_amendments asgset,

310: elsif ln_asg_set is not null then
311:
312: lv_sql_string :=
313: 'select distinct paf.person_id
314: from hr_assignment_set_amendments asgset,
315: per_all_assignments_f paf
316: where assignment_set_id = ' || ln_asg_set || '
317: and asgset.assignment_id = paf.assignment_id
318: and asgset.include_or_exclude = ''I''

Line 413: from hr_assignment_set_amendments asgset,

409: CURSOR c_selected_asg_set(cp_start_person in number
410: ,cp_end_person in number
411: ,cp_asg_set in number) is
412: select distinct paf.person_id
413: from hr_assignment_set_amendments asgset,
414: per_all_assignments_f paf
415: where assignment_set_id = cp_asg_set
416: and asgset.include_or_exclude = 'I'
417: and paf.assignment_id = asgset.assignment_id