[Home] [Help]
1006: l_pgm pgm_rec;
1007: l_pln ben_pln_cache.g_bgppln_rec;
1008: l_cop ben_cop_cache.g_bgpcop_rec;
1009: l_plip ben_plip_f%ROWTYPE;
1010: l_ptip ben_ptip_f%ROWTYPE;
1011: l_opt ben_opt_f%ROWTYPE;
1012: l_oiplip ben_oiplip_f%ROWTYPE;
1013: l_epa ben_prtn_elig_f%ROWTYPE;
1014: l_plnnip_set ben_pln_cache.g_nipplnpln_cache;
1055: user. (PTIP)*/
1056: AND (
1057: EXISTS
1058: (SELECT NULL
1059: FROM ben_ptip_f ctp
1060: WHERE ctp.pgm_id = pgm.pgm_id
1061: AND ctp.pl_typ_id = NVL(p_pl_typ_id, ctp.pl_typ_id)
1062: AND ctp.business_group_id = pgm.business_group_id
1063: AND p_effective_date BETWEEN ctp.effective_start_date
1570: ben_pl_typ_f ptp,
1571: -- ben_popl_yr_perd cpy,
1572: -- ben_yr_perd yrp,
1573: ben_plip_f plp,
1574: ben_ptip_f ctp
1575: WHERE pln.business_group_id = p_business_group_id
1576: AND pln.pl_id = plp.pl_id
1577: AND p_effective_date BETWEEN pln.effective_start_date
1578: AND pln.effective_end_date
1653: AND cpp.effective_end_date;
1654: --
1655: CURSOR c_ptip IS
1656: SELECT ctp.*
1657: FROM ben_ptip_f ctp
1658: WHERE ctp.business_group_id = p_business_group_id
1659: AND ctp.pgm_id = l_pgm_id
1660: AND ctp.pl_typ_id = l_pln.pl_typ_id
1661: AND ctp.ptip_stat_cd = 'A'
1902: --
1903: -- - Check comp object level changes
1904: --
1905: l_tabname_set(0) := 'ben_pgm_f';
1906: l_tabname_set(1) := 'ben_ptip_f';
1907: l_tabname_set(2) := 'ben_plip_f';
1908: l_tabname_set(3) := 'ben_pl_f';
1909: l_tabname_set(4) := 'ben_opt_f';
1910: l_tabname_set(5) := 'ben_oipl_f';
2903: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;
2904: --
2905: CURSOR c_ptip (cv_ptip_id number) IS
2906: SELECT ctp.drvbl_fctr_prtn_elig_flag, ctp.drvbl_fctr_apls_rts_flag, ctp.trk_inelig_per_flag
2907: FROM ben_ptip_f ctp
2908: WHERE ctp.ptip_id = cv_ptip_id
2909: AND ctp.ptip_stat_cd = 'A'
2910: AND p_effective_date BETWEEN ctp.effective_start_date AND ctp.effective_end_date;
2911: --