[Home] [Help]
4768: --
4769: cursor c2(p_pl_id in number) is
4770: select null
4771: from ben_pl_regn_f prg
4772: ,ben_regn_f reg
4773: where prg.pl_id = p_pl_id
4774: and prg.regn_id = reg.regn_id
4775: and reg.sttry_citn_name = 'COBRA'
4776: and prg.business_group_id = p_business_group_id
5132: and epo.elig_flag = 'Y'
5133: and ( c_only_pls_subj_cobra_flag = 'N'
5134: or exists (select null
5135: from ben_pl_regn_f prg,
5136: ben_regn_f reg
5137: where prg.pl_id = pln.pl_id
5138: and c_effective_date between prg.effective_start_date
5139: and prg.effective_end_date
5140: and reg.regn_id = prg.regn_id
5155: from ben_pl_f pln,
5156: ben_plip_f cpp,
5157: ben_ptip_f ctp,
5158: ben_pl_regn_f prg,
5159: ben_regn_f reg,
5160: ben_elig_per_f epo,
5161: ben_per_in_ler pil
5162: where pln.pl_id = cpp.pl_id
5163: and pln.business_group_id = c_business_group_id
5185: and epo.elig_flag = 'Y'
5186: and ( c_only_pls_subj_cobra_flag = 'N' -- cobra regulation needed only when the flag is set
5187: or exists (select null
5188: from ben_pl_regn_f prg,
5189: ben_regn_f reg
5190: where prg.pl_id = pln.pl_id
5191: and c_effective_date between prg.effective_start_date
5192: and prg.effective_end_date
5193: and prg.business_group_id = pln.business_group_id
5588: cursor c1(p_pl_id in number) is
5589: select null
5590: from ben_pl_f pln,
5591: ben_pl_regn_f prg,
5592: ben_regn_f reg
5593: where pln.pl_id = p_pl_id
5594: and pln.business_group_id = p_business_group_id
5595: and l_date_to_use
5596: between pln.effective_start_date