DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_LER_BNFT_RSTRN_F

Line 5791: from ben_ler_bnft_rstrn_f rstrn,

5787: cursor c_ler_rstrn(p_effective_date date,
5788: p_per_in_ler_id number,
5789: p_pl_id number) is
5790: select rstrn.cvg_incr_r_decr_only_cd
5791: from ben_ler_bnft_rstrn_f rstrn,
5792: ben_per_in_ler pil
5793: where rstrn.ler_id = pil.ler_id
5794: and rstrn.pl_id = p_pl_id
5795: and pil.per_in_ler_id = p_per_in_ler_id

Line 6186: from ben_ler_bnft_rstrn_f rstrn,

6182: cursor c_ler_rstrn(p_effective_date date,
6183: p_per_in_ler_id number,
6184: p_pl_id number) is
6185: select rstrn.cvg_incr_r_decr_only_cd
6186: from ben_ler_bnft_rstrn_f rstrn,
6187: ben_per_in_ler pil
6188: where rstrn.ler_id = pil.ler_id
6189: and rstrn.pl_id = p_pl_id
6190: and pil.per_in_ler_id = p_per_in_ler_id