DBA Data[Home] [Help]

APPS.BEN_RECN_REP dependencies on BEN_OIPL_F

Line 602: and apr.oipl_id in ( select oipl_id from ben_oipl_f oipl

598: and popl.business_group_id = p_business_group_id
599: and p_run_date between prm.effective_start_date and prm.effective_end_date
600: and ( ( apr.oipl_id is null and apr.pl_id = p_pl_id )
601: or ( apr.pl_id is null
602: and apr.oipl_id in ( select oipl_id from ben_oipl_f oipl
603: where oipl.pl_id = p_pl_id
604: and oipl.business_group_id = p_business_group_id
605: and p_run_date between oipl.effective_start_date and oipl.effective_end_date )))
606: and (p_payroll_id is null or asg.payroll_id = p_payroll_id )