DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_LER_BNFT_RSTRN_F

Line 5869: from ben_ler_bnft_rstrn_f rstrn,

5865: cursor c_ler_rstrn(p_effective_date date,
5866: p_per_in_ler_id number,
5867: p_pl_id number) is
5868: select rstrn.cvg_incr_r_decr_only_cd
5869: from ben_ler_bnft_rstrn_f rstrn,
5870: ben_per_in_ler pil
5871: where rstrn.ler_id = pil.ler_id
5872: and rstrn.pl_id = p_pl_id
5873: and pil.per_in_ler_id = p_per_in_ler_id

Line 6264: from ben_ler_bnft_rstrn_f rstrn,

6260: cursor c_ler_rstrn(p_effective_date date,
6261: p_per_in_ler_id number,
6262: p_pl_id number) is
6263: select rstrn.cvg_incr_r_decr_only_cd
6264: from ben_ler_bnft_rstrn_f rstrn,
6265: ben_per_in_ler pil
6266: where rstrn.ler_id = pil.ler_id
6267: and rstrn.pl_id = p_pl_id
6268: and pil.per_in_ler_id = p_per_in_ler_id