APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_OIPL_F

Line 1060: select opt_id from ben_oipl_f oipl

1056: l_look_back_dt date ;
1057:
1058: -- Concurrent Code Begin
1059: cursor c_opt(l_oipl_id number) is
1060: select opt_id from ben_oipl_f oipl
1061: where oipl.oipl_id = l_oipl_id
1062: and p_effective_date between
1063: oipl.effective_start_date and oipl.effective_end_date;
1064: l_opt c_opt%rowtype;