DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4_CANCEL_PKG dependencies on PAY_POPULATION_RANGES

Line 493: pay_population_ranges ppr

489: from hr_assignment_set_amendments asgset,
490: per_assignments_f paf,
491: pay_payroll_actions ppa,
492: pay_assignment_actions paa,
493: pay_population_ranges ppr
494: where asgset.assignment_set_id = cp_asg_set
495: and asgset.include_or_exclude = 'I'
496: and paf.assignment_id = asgset.assignment_id
497: -- and paf.person_id between cp_start_person

Line 566: pay_population_ranges ppr

562: select distinct paf.person_id
563: from pay_payroll_actions ppa_rep,
564: pay_assignment_actions paa_rep,
565: per_assignments_f paf,
566: pay_population_ranges ppr
567: where ppa_rep.business_group_id = cp_bg_id
568: and ppa_rep.report_type in ('T4_XML','PAYCAT4AMPDF')
569: and ppa_rep.report_qualifier = 'DEFAULT'
570: and ppa_rep.effective_date = cp_eff_date