[Home] [Help]
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: --
8369: if g_debug then
9767: cursor c_ptip_pl_id(p_gsp_pgm_id number,
9768: p_gsp_plip_id number) is
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
9828: ptip.no_mn_pl_typ_overid_flag,
9829: plt.name,
9830: Plt.MN_ENRL_RQD_NUM,
9831: plt.MX_ENRL_ALWD_NUM
9832: from ben_ptip_f ptip
9833: , ben_pl_typ_f plt
9834: where ptip.ptip_id = p_ptip_id
9835: and ptip.pl_typ_id = plt.pl_typ_id
9836: and ptip.business_group_id = p_business_group_id
9856: l_count number(15);
9857: l_pep_row ben_derive_part_and_rate_facts.g_cache_structure;
9858: l_chk_min_max varchar2(30);
9859: l_ptip_elig_flag varchar2(30);
9860: l_MN_ENRD_RQD_OVRID_NUM ben_ptip_f.MN_ENRD_RQD_OVRID_NUM%type;
9861: --
9862: -- End Min Max enhancement.
9863: --
9864: l_rec_ptnl_ler_for_per_id number;
9882: l_paretprpl_row ben_elig_to_prte_rsn_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;
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;
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;