APPS.BEN_ICM_LIFE_EVENTS dependencies on BEN_OIPL_F

Line 279: FROM ben_oipl_f

275: --
276: CURSOR c_opt_id (p_oipl_id NUMBER)
277: IS
278: SELECT opt_id, pl_id
279: FROM ben_oipl_f
280: WHERE oipl_id = p_oipl_id;
281:
282: --
283: l_opt_id c_opt_id%ROWTYPE;

Line 666: FROM ben_oipl_f

662: --
663: /* CURSOR c_trk_inelig_per_flag (p_opt_id NUMBER)
664: IS
665: SELECT trk_inelig_per_flag
666: FROM ben_oipl_f
667: WHERE opt_id = p_opt_id;
668:
669: --
670: l_trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%TYPE;

Line 670: l_trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%TYPE;

666: FROM ben_oipl_f
667: WHERE opt_id = p_opt_id;
668:
669: --
670: l_trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%TYPE;
671:
672: --
673: CURSOR c_pep_ovn (p_elig_per_id IN NUMBER)
674: IS