DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PAY_POPULATION_RANGES

Line 476: pay_population_ranges ppr

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
477: where asgset.assignment_set_id = cp_asg_set
478: and asgset.include_or_exclude = 'I'
479: and paf.assignment_id = asgset.assignment_id
480: --and paf.person_id between cp_start_person

Line 554: pay_population_ranges ppr

550: cp_end_person number) is
551: select distinct paa_arch.serial_number
552: from pay_payroll_actions ppa_arch,
553: pay_assignment_actions paa_arch,
554: pay_population_ranges ppr
555: where ppa_arch.business_group_id = cp_bg_id
556: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
557: AND ppa_arch.report_qualifier = 'CAEOY_RL1_AMEND_PPQ'
558: and ppa_arch.effective_date = cp_eff_date