DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2181: and exists ( select 1 from pay_run_types_f prt

2177: and ppa.payroll_action_id = paa.payroll_action_id
2178: and ppa.effective_date <= cp_eff_date
2179: and ppa.action_type in ('R', 'Q')
2180: and ppa.effective_date between paf.effective_start_date and paf.effective_end_date
2181: and exists ( select 1 from pay_run_types_f prt
2182: where prt.legislation_code = 'CA'
2183: and prt.run_type_id = paa.run_type_id
2184: and prt.run_method <> 'C' );
2185: