[Home] [Help]
4715: --
4716: cursor c2(p_pl_id in number) is
4717: select null
4718: from ben_pl_regn_f prg
4719: ,ben_regn_f reg
4720: where prg.pl_id = p_pl_id
4721: and prg.regn_id = reg.regn_id
4722: and reg.sttry_citn_name = 'COBRA'
4723: and prg.business_group_id = p_business_group_id
5075: and epo.elig_flag = 'Y'
5076: and ( c_only_pls_subj_cobra_flag = 'N'
5077: or exists (select null
5078: from ben_pl_regn_f prg,
5079: ben_regn_f reg
5080: where prg.pl_id = pln.pl_id
5081: and c_effective_date between prg.effective_start_date
5082: and prg.effective_end_date
5083: and reg.regn_id = prg.regn_id
5098: from ben_pl_f pln,
5099: ben_plip_f cpp,
5100: ben_ptip_f ctp,
5101: ben_pl_regn_f prg,
5102: ben_regn_f reg,
5103: ben_elig_per_f epo,
5104: ben_per_in_ler pil
5105: where pln.pl_id = cpp.pl_id
5106: and pln.business_group_id = c_business_group_id
5128: and epo.elig_flag = 'Y'
5129: and ( c_only_pls_subj_cobra_flag = 'N' -- cobra regulation needed only when the flag is set
5130: or exists (select null
5131: from ben_pl_regn_f prg,
5132: ben_regn_f reg
5133: where prg.pl_id = pln.pl_id
5134: and c_effective_date between prg.effective_start_date
5135: and prg.effective_end_date
5136: and prg.business_group_id = pln.business_group_id
5531: cursor c1(p_pl_id in number) is
5532: select null
5533: from ben_pl_f pln,
5534: ben_pl_regn_f prg,
5535: ben_regn_f reg
5536: where pln.pl_id = p_pl_id
5537: and pln.business_group_id = p_business_group_id
5538: and l_date_to_use
5539: between pln.effective_start_date