APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_PLIP_F

Line 8364: l_plip_rec ben_plip_f%rowtype;

8360: l_pgm_rec ben_pgm_f%rowtype;
8361: l_pl_rec ben_pl_f%rowtype;
8362: l_oipl_rec ben_oipl_f%rowtype;
8363: l_opt_rec ben_opt_f%rowtype;
8364: l_plip_rec ben_plip_f%rowtype;
8365: l_ptip_rec ben_ptip_f%rowtype;
8366: --
8367: begin
8368: --

Line 9773: ben_plip_f plip

9769: select ptip.ptip_id,
9770: pln.pl_id
9771: from ben_ptip_f ptip,
9772: ben_pl_f pln,
9773: ben_plip_f plip
9774: where plip.plip_id = p_gsp_plip_id
9775: and plip.pgm_id = p_gsp_pgm_id
9776: and p_effective_date between plip.effective_start_date
9777: and plip.effective_end_date

Line 9887: l_currplip_row ben_plip_f%rowtype;

9883: l_currpe_row ben_prtn_elig_f%rowtype;
9884: l_curretpr_row ben_elig_to_prte_rsn_f%rowtype;
9885: l_currpgm_row ben_pgm_f%rowtype;
9886: l_currptip_row ben_ptip_f%rowtype;
9887: l_currplip_row ben_plip_f%rowtype;
9888: l_currpl_row ben_pl_f%rowtype;
9889: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
9890: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
9891: l_parpgm_row ben_pgm_f%rowtype;

Line 9893: l_parplip_row ben_plip_f%rowtype;

9889: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
9890: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
9891: l_parpgm_row ben_pgm_f%rowtype;
9892: l_parptip_row ben_ptip_f%rowtype;
9893: l_parplip_row ben_plip_f%rowtype;
9894: l_parpl_row ben_pl_f%rowtype;
9895: l_paropt_row ben_cobj_cache.g_opt_inst_row;
9896: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;
9897: l_per_row per_all_people_F%rowtype;