DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 288: from hr_assignment_set_amendments asgset,

284: elsif ln_asg_set is not null then
285:
286: lv_sql_string :=
287: 'select distinct paf.person_id
288: from hr_assignment_set_amendments asgset,
289: per_all_assignments_f paf
290: where assignment_set_id = ' || to_char(ln_asg_set) || '
291: and asgset.assignment_id = paf.assignment_id
292: and asgset.include_or_exclude = ''I''

Line 387: from hr_assignment_set_amendments asgset,

383: CURSOR c_selected_asg_set(cp_start_person in number
384: ,cp_end_person in number
385: ,cp_asg_set in number) is
386: select distinct paf.person_id
387: from hr_assignment_set_amendments asgset,
388: per_all_assignments_f paf,
389: pay_assignment_actions paa,
390: pay_payroll_actions ppa
391: where

Line 418: from hr_assignment_set_amendments asgset,

414: CURSOR c_selected_asg_set_range(cp_start_person in number
415: ,cp_end_person in number
416: ,cp_asg_set in number) is
417: select distinct paf.person_id
418: from hr_assignment_set_amendments asgset,
419: per_all_assignments_f paf,
420: pay_assignment_actions paa,
421: pay_payroll_actions ppa,
422: pay_population_ranges ppr