APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_OIPL_F

Line 1047: select opt_id from ben_oipl_f oipl

1043: l_look_back_dt date ;
1044:
1045: -- Concurrent Code Begin
1046: cursor c_opt(l_oipl_id number) is
1047: select opt_id from ben_oipl_f oipl
1048: where oipl.oipl_id = l_oipl_id
1049: and p_effective_date between
1050: oipl.effective_start_date and oipl.effective_end_date;
1051: l_opt c_opt%rowtype;