DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on PAY_POPULATION_RANGES

Line 449: pay_population_ranges ppr

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

Line 521: pay_population_ranges ppr

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