eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_CBR_PER_IN_LER

Line 1310: -- BEN_CBR_PER_IN_LER (CRP) - (not deleted, join to pil to check status).

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: --
1312: -- PIL
1313: -- |
1314: -- ---------------------------------

Line 3361: ,ben_cbr_per_in_ler crp

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
3365: and crp.per_in_ler_id = p_per_in_ler_id