DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 331: from hr_assignment_set_amendments asgset,

327: elsif ln_asg_set is not null then
328:
329: lv_sql_string :=
330: 'select distinct paf.person_id
331: from hr_assignment_set_amendments asgset,
332: per_assignments_f paf
333: where assignment_set_id = ' || ln_asg_set || '
334: and asgset.assignment_id = paf.assignment_id
335: and asgset.include_or_exclude = ''I''

Line 445: from hr_assignment_set_amendments asgset,

441: ,cp_end_person in number
442: ,cp_asg_set in number
443: ,cp_effective_date in date) is
444: select distinct paf.person_id
445: from hr_assignment_set_amendments asgset,
446: per_assignments_f paf,
447: pay_payroll_actions ppa_arch,
448: pay_assignment_actions paa_arch
449: where asgset.assignment_set_id = cp_asg_set

Line 472: from hr_assignment_set_amendments asgset,

468: ,cp_end_person in number
469: ,cp_asg_set in number
470: ,cp_effective_date in date) is
471: select distinct paf.person_id
472: from hr_assignment_set_amendments asgset,
473: per_assignments_f paf,
474: pay_payroll_actions ppa_arch,
475: pay_assignment_actions paa_arch,
476: pay_population_ranges ppr