[Home] [Help]
8769: l_pl_rec ben_pl_f%rowtype;
8770: l_oipl_rec ben_oipl_f%rowtype;
8771: l_opt_rec ben_opt_f%rowtype;
8772: l_plip_rec ben_plip_f%rowtype;
8773: l_ptip_rec ben_ptip_f%rowtype;
8774: --
8775: begin
8776: --
8777: if g_debug then
10175: cursor c_ptip_pl_id(p_gsp_pgm_id number,
10176: p_gsp_plip_id number) is
10177: select ptip.ptip_id,
10178: pln.pl_id
10179: from ben_ptip_f ptip,
10180: ben_pl_f pln,
10181: ben_plip_f plip
10182: where plip.plip_id = p_gsp_plip_id
10183: and plip.pgm_id = p_gsp_pgm_id
10236: ptip.no_mn_pl_typ_overid_flag,
10237: plt.name,
10238: Plt.MN_ENRL_RQD_NUM,
10239: plt.MX_ENRL_ALWD_NUM
10240: from ben_ptip_f ptip
10241: , ben_pl_typ_f plt
10242: where ptip.ptip_id = p_ptip_id
10243: and ptip.pl_typ_id = plt.pl_typ_id
10244: and ptip.business_group_id = p_business_group_id
10312: l_count number(15);
10313: l_pep_row ben_derive_part_and_rate_facts.g_cache_structure;
10314: l_chk_min_max varchar2(30);
10315: l_ptip_elig_flag varchar2(30);
10316: l_MN_ENRD_RQD_OVRID_NUM ben_ptip_f.MN_ENRD_RQD_OVRID_NUM%type;
10317: --
10318: -- End Min Max enhancement.
10319: --
10320: l_rec_ptnl_ler_for_per_id number;
10338: l_paretprpl_row ben_elig_to_prte_rsn_f%rowtype;
10339: l_currpe_row ben_prtn_elig_f%rowtype;
10340: l_curretpr_row ben_elig_to_prte_rsn_f%rowtype;
10341: l_currpgm_row ben_pgm_f%rowtype;
10342: l_currptip_row ben_ptip_f%rowtype;
10343: l_currplip_row ben_plip_f%rowtype;
10344: l_currpl_row ben_pl_f%rowtype;
10345: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10346: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10344: l_currpl_row ben_pl_f%rowtype;
10345: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10346: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10347: l_parpgm_row ben_pgm_f%rowtype;
10348: l_parptip_row ben_ptip_f%rowtype;
10349: l_parplip_row ben_plip_f%rowtype;
10350: l_parpl_row ben_pl_f%rowtype;
10351: l_paropt_row ben_cobj_cache.g_opt_inst_row;
10352: l_paroipl_row ben_cobj_cache.g_oipl_inst_row;