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_PIL_ELCTBL_CHC_POPL

Line 47: BEN_PIL_ELCTBL_CHC_POPL

43: We need to replace with new cm
44: tables.
45: Added multi-row parm to rslt call
46: 31-Dec-98 maagrawa 115.9 Added new delete sections for
47: BEN_PIL_ELCTBL_CHC_POPL
48: BEN_PER_CM_F
49: - BEN_PER_CM_PRVDD_F
50: - BEN_PER_CM_TRGR_F
51: - BEN_PER_CM_USG_F

Line 94: ben_elig_cvrd_dpnt_f, ben_pil_elctbl_chc_popl,

90: pl_bnf_ctfn_prvdd,all per_cm% tables.
91: Removed because of per_in_ler status checks
92: 08-jul-99 pbodla 115.17 Code to backup data from ben_pl_bnf_f, BEN_PRTT_RT_VAL,
93: ben_prtt_prem, ben_elig_per, ben_elig_per_opt
94: ben_elig_cvrd_dpnt_f, ben_pil_elctbl_chc_popl,
95: ben_prtt_enrt_rslt_f added.
96: 09-jul-99 shdas 115.18 Moved unprocess_ptnl_ler proc here from benptnle.
97: 15-jul-99 jcarpent 115.19 Added calls to ben_ext_chlg.log_benefit_chg
98: 24-Aug-99 maagrawa 115.20 Dependents table changes.

Line 1504: from ben_pil_elctbl_chc_popl

1500: -- CWB Bug 2712602
1501: --
1502: cursor c_pel is
1503: select pil_elctbl_chc_popl_id
1504: from ben_pil_elctbl_chc_popl
1505: where per_in_ler_id = p_per_in_ler_id;
1506: --
1507: l_pil_elctbl_chc_popl_id number;
1508:

Line 1814: delete_routine(p_routine => 'BEN_PIL_ELCTBL_CHC_POPL',

1810: end if;
1811:
1812: if p_bckdt_prtt_enrt_rslt_id is null then
1813: -- mark pil popl's 'backed out'
1814: delete_routine(p_routine => 'BEN_PIL_ELCTBL_CHC_POPL',
1815: p_per_in_ler_id => p_per_in_ler_id,
1816: p_business_group_id => p_business_group_id,
1817: p_copy_only => p_copy_only,
1818: p_effective_date => p_effective_date);

Line 3794: -- START ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL

3790: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
3791: order by bpl.effective_end_date desc;
3792: -- END ---> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3793:
3794: -- START ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3795: -- -- Source Table -- BEN_PER_IN_LER --
3796: cursor c_ben_pil_elctbl_chc_popl is
3797: select pel.pil_elctbl_chc_popl_id,
3798: pel.object_version_number

Line 3796: cursor c_ben_pil_elctbl_chc_popl is

3792: -- END ---> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3793:
3794: -- START ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3795: -- -- Source Table -- BEN_PER_IN_LER --
3796: cursor c_ben_pil_elctbl_chc_popl is
3797: select pel.pil_elctbl_chc_popl_id,
3798: pel.object_version_number
3799: from ben_pil_elctbl_chc_popl pel,
3800: ben_per_in_ler pil

Line 3799: from ben_pil_elctbl_chc_popl pel,

3795: -- -- Source Table -- BEN_PER_IN_LER --
3796: cursor c_ben_pil_elctbl_chc_popl is
3797: select pel.pil_elctbl_chc_popl_id,
3798: pel.object_version_number
3799: from ben_pil_elctbl_chc_popl pel,
3800: ben_per_in_ler pil
3801: where pil.per_in_ler_id = p_per_in_ler_id
3802: and pil.business_group_id = p_business_group_id
3803: and pel.per_in_ler_id = pil.per_in_ler_id

Line 3806: -- END ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL

3802: and pil.business_group_id = p_business_group_id
3803: and pel.per_in_ler_id = pil.per_in_ler_id
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

Line 7131: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then

7127: end loop;
7128: --
7129: close c_ben_bnft_prvdd_ldgr_f;
7130: --
7131: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then
7132:
7133: -- pil popl's are updated to 'backed out'
7134: if nvl(p_copy_only,'N') <> 'Y' then
7135: open c_ben_pil_elctbl_chc_popl;

Line 7135: open c_ben_pil_elctbl_chc_popl;

7131: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then
7132:
7133: -- pil popl's are updated to 'backed out'
7134: if nvl(p_copy_only,'N') <> 'Y' then
7135: open c_ben_pil_elctbl_chc_popl;
7136:
7137: loop
7138:
7139: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,

Line 7139: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,

7135: open c_ben_pil_elctbl_chc_popl;
7136:
7137: loop
7138:
7139: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,
7140: l_object_version_number;
7141: exit when c_ben_pil_elctbl_chc_popl%notfound;
7142: --
7143: -- Delete from the appropriate API.

Line 7141: exit when c_ben_pil_elctbl_chc_popl%notfound;

7137: loop
7138:
7139: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,
7140: l_object_version_number;
7141: exit when c_ben_pil_elctbl_chc_popl%notfound;
7142: --
7143: -- Delete from the appropriate API.
7144: --
7145: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

Line 7145: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

7141: exit when c_ben_pil_elctbl_chc_popl%notfound;
7142: --
7143: -- Delete from the appropriate API.
7144: --
7145: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
7146: (p_validate => false,
7147: p_pil_elctbl_chc_popl_id => l_pk_id,
7148: p_pil_elctbl_popl_stat_cd => 'BCKDT',
7149: p_object_version_number => l_object_version_number,

Line 7154: close c_ben_pil_elctbl_chc_popl;

7150: p_effective_date => p_effective_date);
7151:
7152: end loop;
7153:
7154: close c_ben_pil_elctbl_chc_popl;
7155: end if ;
7156: --
7157: elsif p_routine = 'BEN_CBR_QUALD_BNF' then
7158: --

Line 7309: if c_ben_pil_elctbl_chc_popl%isopen then

7305: close c_ben_prtt_enrt_rslt_f;
7306: --
7307: end if;
7308: --
7309: if c_ben_pil_elctbl_chc_popl%isopen then
7310: --
7311: close c_ben_pil_elctbl_chc_popl;
7312: --
7313: end if;

Line 7311: close c_ben_pil_elctbl_chc_popl;

7307: end if;
7308: --
7309: if c_ben_pil_elctbl_chc_popl%isopen then
7310: --
7311: close c_ben_pil_elctbl_chc_popl;
7312: --
7313: end if;
7314: --
7315: raise;