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 1307: -- BEN_CBR_QUALD_BNF (CQB) - (not deleted, if it is the initial qualifying event, join

1303: -- BEN_PER_CM_PRVDD_F (PCD) (join to pil to check status)
1304: -- PAY_ELEMENT_ENTRIES_F (PEE)
1305: -- PAY_ELEMENT_ENTRY_VALUES_F (PEV)
1306: -- BEN_PRTT_PREM_F (PPE)
1307: -- BEN_CBR_QUALD_BNF (CQB) - (not deleted, if it is the initial qualifying event, join
1308: -- to pil to check status. If it is not the initial
1309: -- qualifying event, restore the prior eligibility end date.)
1310: -- BEN_CBR_PER_IN_LER (CRP) - (not deleted, join to pil to check status).
1311: --

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

1490: --
1491: -- If applicable, update the eligibility end date to the eligibility
1492: -- end date of the prior event.
1493: --
1494: delete_routine(p_routine => 'BEN_CBR_QUALD_BNF',
1495: p_per_in_ler_id => p_per_in_ler_id,
1496: p_business_group_id => p_business_group_id,
1497: p_copy_only => p_copy_only,
1498: p_effective_date => p_effective_date);

Line 3356: -- BEN_CBR_QUALD_BNF

3352: and pel.business_group_id = pil.business_group_id;
3353: --
3354: -- END ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3355: --
3356: -- BEN_CBR_QUALD_BNF
3357: --
3358: cursor c_get_cbr_quald_bnf is
3359: select cqb.*,crp.prvs_elig_perd_end_dt
3360: from ben_cbr_quald_bnf cqb

Line 3360: from ben_cbr_quald_bnf cqb

3356: -- BEN_CBR_QUALD_BNF
3357: --
3358: cursor c_get_cbr_quald_bnf is
3359: select cqb.*,crp.prvs_elig_perd_end_dt
3360: from ben_cbr_quald_bnf cqb
3361: ,ben_cbr_per_in_ler crp
3362: where cqb.cbr_quald_bnf_id = crp.cbr_quald_bnf_id
3363: and cqb.business_group_id = p_business_group_id
3364: and cqb.business_group_id = crp.business_group_id

Line 6505: elsif p_routine = 'BEN_CBR_QUALD_BNF' then

6501:
6502: close c_ben_pil_elctbl_chc_popl;
6503: end if ;
6504: --
6505: elsif p_routine = 'BEN_CBR_QUALD_BNF' then
6506: --
6507: -- Restore prior cobra eligibility end date.
6508: --
6509:

Line 6515: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

6511: --
6512: l_object_version_number := l_cqb_rec.object_version_number;
6513: --
6514: if nvl(p_copy_only,'N') <> 'Y' then
6515: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
6516: (p_validate => false
6517: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id
6518: ,p_quald_bnf_flag => 'Y'
6519: ,p_cbr_elig_perd_end_dt => l_cqb_rec.prvs_elig_perd_end_dt

Line 6530: open c_bkp_row('BEN_CBR_QUALD_BNF',

6526: -- Copy to backup table to restore if neccessary.
6527: --
6528: --
6529: end if ;
6530: open c_bkp_row('BEN_CBR_QUALD_BNF',
6531: p_per_in_ler_id,
6532: l_cqb_rec.cbr_quald_bnf_id,
6533: l_object_version_number);
6534: fetch c_bkp_row into l_row_id;

Line 6553: 'BEN_CBR_QUALD_BNF',

6549: business_group_id,
6550: object_version_number
6551: )
6552: values (
6553: 'BEN_CBR_QUALD_BNF',
6554: l_cqb_rec.cbr_quald_bnf_id,
6555: l_cqb_rec.quald_bnf_flag,
6556: l_cqb_rec.cbr_elig_perd_strt_dt,
6557: l_cqb_rec.cbr_elig_perd_end_dt,