APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_CBR_QUALD_BNF

Line 378: and inelg_rsn_cd for BEN_CBR_QUALD_BNF. Also,

374: 06-Oct-2005 abparekh 115.123 Bug 4642315 : In procedure UNPROCESS_SUSP_ENRT_PAST_PIL,
375: while deleting PEA, call API only once for
376: every PEA_Id
377: 06-Oct-2005 stee 115.124 Bug Bug#4486609 - Back up the quald_bnf_flag
378: and inelg_rsn_cd for BEN_CBR_QUALD_BNF. Also,
379: set the quald_bnf_flag = 'Y' and inelg_rsn_cd
380: to null when an event is backed out.
381: 07-oct-05 ssarkar 115.125 bug: 4615207 - Mulitple Rate chk to be performed only for GHR
382: 02-Jan-2006 abparekh 115.126 Bug 4919951 : Reset G_BACKOUT_FLAG in case of any exception

Line 1655: -- BEN_CBR_QUALD_BNF (CQB) - (not deleted, if it is the initial qualifying event, join

1651: -- BEN_PER_CM_PRVDD_F (PCD) (join to pil to check status)
1652: -- PAY_ELEMENT_ENTRIES_F (PEE)
1653: -- PAY_ELEMENT_ENTRY_VALUES_F (PEV)
1654: -- BEN_PRTT_PREM_F (PPE)
1655: -- BEN_CBR_QUALD_BNF (CQB) - (not deleted, if it is the initial qualifying event, join
1656: -- to pil to check status. If it is not the initial
1657: -- qualifying event, restore the prior eligibility end date.)
1658: -- BEN_CBR_PER_IN_LER (CRP) - (not deleted, join to pil to check status).
1659: --

Line 1842: delete_routine(p_routine => 'BEN_CBR_QUALD_BNF',

1838: --
1839: -- If applicable, update the eligibility end date to the eligibility
1840: -- end date of the prior event.
1841: --
1842: delete_routine(p_routine => 'BEN_CBR_QUALD_BNF',
1843: p_per_in_ler_id => p_per_in_ler_id,
1844: p_business_group_id => p_business_group_id,
1845: p_copy_only => p_copy_only,
1846: p_effective_date => p_effective_date);

Line 3808: -- BEN_CBR_QUALD_BNF

3804: and pel.business_group_id = pil.business_group_id;
3805: --
3806: -- END ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3807: --
3808: -- BEN_CBR_QUALD_BNF
3809: --
3810: cursor c_get_cbr_quald_bnf is
3811: select cqb.*,crp.prvs_elig_perd_end_dt
3812: from ben_cbr_quald_bnf cqb

Line 3812: from ben_cbr_quald_bnf cqb

3808: -- BEN_CBR_QUALD_BNF
3809: --
3810: cursor c_get_cbr_quald_bnf is
3811: select cqb.*,crp.prvs_elig_perd_end_dt
3812: from ben_cbr_quald_bnf cqb
3813: ,ben_cbr_per_in_ler crp
3814: where cqb.cbr_quald_bnf_id = crp.cbr_quald_bnf_id
3815: and cqb.business_group_id = p_business_group_id
3816: and cqb.business_group_id = crp.business_group_id

Line 7157: elsif p_routine = 'BEN_CBR_QUALD_BNF' then

7153:
7154: close c_ben_pil_elctbl_chc_popl;
7155: end if ;
7156: --
7157: elsif p_routine = 'BEN_CBR_QUALD_BNF' then
7158: --
7159: -- Restore prior cobra eligibility end date.
7160: --
7161:

Line 7167: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

7163: --
7164: l_object_version_number := l_cqb_rec.object_version_number;
7165: --
7166: if nvl(p_copy_only,'N') <> 'Y' then
7167: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
7168: (p_validate => false
7169: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id
7170: ,p_quald_bnf_flag => 'Y'
7171: ,p_cbr_elig_perd_end_dt => l_cqb_rec.prvs_elig_perd_end_dt

Line 7182: open c_bkp_row('BEN_CBR_QUALD_BNF',

7178: -- Copy to backup table to restore if neccessary.
7179: --
7180: --
7181: end if ;
7182: open c_bkp_row('BEN_CBR_QUALD_BNF',
7183: p_per_in_ler_id,
7184: l_cqb_rec.cbr_quald_bnf_id,
7185: l_object_version_number);
7186: fetch c_bkp_row into l_row_id;

Line 7205: 'BEN_CBR_QUALD_BNF',

7201: business_group_id,
7202: object_version_number
7203: )
7204: values (
7205: 'BEN_CBR_QUALD_BNF',
7206: l_cqb_rec.cbr_quald_bnf_id,
7207: l_cqb_rec.quald_bnf_flag,
7208: l_cqb_rec.cbr_elig_perd_strt_dt,
7209: l_cqb_rec.cbr_elig_perd_end_dt,