DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PAY_POPULATION_RANGES

Line 508: pay_population_ranges ppr

504: from hr_assignment_set_amendments asgset,
505: per_assignments_f paf,
506: pay_payroll_actions ppa,
507: pay_assignment_actions paa,
508: pay_population_ranges ppr
509: where asgset.assignment_set_id = cp_asg_set
510: and asgset.include_or_exclude = 'I'
511: and paf.assignment_id = asgset.assignment_id
512: --and paf.person_id between cp_start_person

Line 579: pay_population_ranges ppr

575: cp_end_person number) is
576: select distinct paa_arch.serial_number
577: from pay_payroll_actions ppa_arch,
578: pay_assignment_actions paa_arch,
579: pay_population_ranges ppr
580: where ppa_arch.business_group_id = cp_bg_id
581: and ppa_arch.report_type = 'CAEOY_T4_AMEND_PP'
582: AND ppa_arch.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
583: and ppa_arch.effective_date = cp_eff_date