[Home] [Help]
1021: l_pgm pgm_rec;
1022: l_pln ben_pln_cache.g_bgppln_rec;
1023: l_cop ben_cop_cache.g_bgpcop_rec;
1024: l_plip ben_plip_f%ROWTYPE;
1025: l_ptip ben_ptip_f%ROWTYPE;
1026: l_opt ben_opt_f%ROWTYPE;
1027: l_oiplip ben_oiplip_f%ROWTYPE;
1028: l_epa ben_prtn_elig_f%ROWTYPE;
1029: l_plnnip_set ben_pln_cache.g_nipplnpln_cache;
1070: user. (PTIP)*/
1071: AND (
1072: EXISTS
1073: (SELECT NULL
1074: FROM ben_ptip_f ctp
1075: WHERE ctp.pgm_id = pgm.pgm_id
1076: AND ctp.pl_typ_id = NVL(p_pl_typ_id, ctp.pl_typ_id)
1077: AND ctp.business_group_id = pgm.business_group_id
1078: AND p_effective_date BETWEEN ctp.effective_start_date
1585: ben_pl_typ_f ptp,
1586: -- ben_popl_yr_perd cpy,
1587: -- ben_yr_perd yrp,
1588: ben_plip_f plp,
1589: ben_ptip_f ctp
1590: WHERE pln.business_group_id = p_business_group_id
1591: AND pln.pl_id = plp.pl_id
1592: AND p_effective_date BETWEEN pln.effective_start_date
1593: AND pln.effective_end_date
1668: AND cpp.effective_end_date;
1669: --
1670: CURSOR c_ptip IS
1671: SELECT ctp.*
1672: FROM ben_ptip_f ctp
1673: WHERE ctp.business_group_id = p_business_group_id
1674: AND ctp.pgm_id = l_pgm_id
1675: AND ctp.pl_typ_id = l_pln.pl_typ_id
1676: AND ctp.ptip_stat_cd = 'A'
1920: --
1921: -- - Check comp object level changes
1922: --
1923: l_tabname_set(0) := 'ben_pgm_f';
1924: l_tabname_set(1) := 'ben_ptip_f';
1925: l_tabname_set(2) := 'ben_plip_f';
1926: l_tabname_set(3) := 'ben_pl_f';
1927: l_tabname_set(4) := 'ben_opt_f';
1928: l_tabname_set(5) := 'ben_oipl_f';
2923: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;
2924: --
2925: CURSOR c_ptip (cv_ptip_id number) IS
2926: SELECT ctp.drvbl_fctr_prtn_elig_flag, ctp.drvbl_fctr_apls_rts_flag, ctp.trk_inelig_per_flag
2927: FROM ben_ptip_f ctp
2928: WHERE ctp.ptip_id = cv_ptip_id
2929: AND ctp.ptip_stat_cd = 'A'
2930: AND p_effective_date BETWEEN ctp.effective_start_date AND ctp.effective_end_date;
2931: --