DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_CANCEL_PKG dependencies on PAY_POPULATION_RANGES

Line 448: pay_population_ranges ppr

444: from hr_assignment_set_amendments asgset,
445: per_assignments_f paf,
446: pay_payroll_actions ppa,
447: pay_assignment_actions paa,
448: pay_population_ranges ppr
449: where asgset.assignment_set_id = cp_asg_set
450: and asgset.include_or_exclude = 'I'
451: and paf.assignment_id = asgset.assignment_id
452: --and paf.person_id between cp_start_person

Line 520: pay_population_ranges ppr

516: select distinct paf.person_id
517: from pay_payroll_actions ppa_rep,
518: pay_assignment_actions paa_rep,
519: per_assignments_f paf,
520: pay_population_ranges ppr
521: where ppa_rep.business_group_id = cp_bg_id
522: and ppa_rep.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
523: and ppa_rep.report_qualifier = 'DEFAULT'
524: and ppa_rep.effective_date = cp_eff_date