DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on PAY_POPULATION_RANGES

Line 455: pay_population_ranges ppr

451: from hr_assignment_set_amendments asgset,
452: per_assignments_f paf,
453: pay_payroll_actions ppa,
454: pay_assignment_actions paa,
455: pay_population_ranges ppr
456: where asgset.assignment_set_id = cp_asg_set
457: and asgset.include_or_exclude = 'I'
458: and paf.assignment_id = asgset.assignment_id
459: -- and paf.person_id between cp_start_person

Line 528: pay_population_ranges ppr

524: select distinct paf.person_id
525: from pay_payroll_actions ppa_rep,
526: pay_assignment_actions paa_rep,
527: per_assignments_f paf,
528: pay_population_ranges ppr
529: where ppa_rep.business_group_id = cp_bg_id
530: and ppa_rep.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
531: and ppa_rep.report_qualifier = 'DEFAULT'
532: and ppa_rep.effective_date = cp_eff_date