DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 3003: and exists ( select 1 from pay_run_types_f prt

2999: and ppa.payroll_action_id = paa.payroll_action_id
3000: and ppa.effective_date <= cp_eff_date
3001: and ppa.action_type in ('R', 'Q')
3002: and ppa.effective_date between paf.effective_start_date and paf.effective_end_date
3003: and exists ( select 1 from pay_run_types_f prt
3004: where prt.legislation_code = 'CA'
3005: and prt.run_type_id = paa.run_type_id
3006: and prt.run_method <> 'C' );
3007: