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 1658: -- BEN_CBR_PER_IN_LER (CRP) - (not deleted, join to pil to check status).

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: --
1660: -- PIL
1661: -- |
1662: -- ---------------------------------

Line 3813: ,ben_cbr_per_in_ler crp

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