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 1190: from ben_pil_elctbl_chc_popl

1186: -- CWB Bug 2712602
1187: --
1188: cursor c_pel is
1189: select pil_elctbl_chc_popl_id
1190: from ben_pil_elctbl_chc_popl
1191: where per_in_ler_id = p_per_in_ler_id;
1192: --
1193: l_pil_elctbl_chc_popl_id number;
1194:

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

1462: end if;
1463:
1464: if p_bckdt_prtt_enrt_rslt_id is null then
1465: -- mark pil popl's 'backed out'
1466: delete_routine(p_routine => 'BEN_PIL_ELCTBL_CHC_POPL',
1467: p_per_in_ler_id => p_per_in_ler_id,
1468: p_business_group_id => p_business_group_id,
1469: p_copy_only => p_copy_only,
1470: p_effective_date => p_effective_date);

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

3338: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
3339: order by bpl.effective_end_date desc;
3340: -- END ---> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3341:
3342: -- START ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3343: -- -- Source Table -- BEN_PER_IN_LER --
3344: cursor c_ben_pil_elctbl_chc_popl is
3345: select pel.pil_elctbl_chc_popl_id,
3346: pel.object_version_number

Line 3344: cursor c_ben_pil_elctbl_chc_popl is

3340: -- END ---> DELETE ROUTINE FOR BEN_BNFT_PRVDD_LDGR_F
3341:
3342: -- START ----> DELETE ROUTINE FOR BEN_PIL_ELCTBL_CHC_POPL
3343: -- -- Source Table -- BEN_PER_IN_LER --
3344: cursor c_ben_pil_elctbl_chc_popl is
3345: select pel.pil_elctbl_chc_popl_id,
3346: pel.object_version_number
3347: from ben_pil_elctbl_chc_popl pel,
3348: ben_per_in_ler pil

Line 3347: from ben_pil_elctbl_chc_popl pel,

3343: -- -- Source Table -- BEN_PER_IN_LER --
3344: cursor c_ben_pil_elctbl_chc_popl is
3345: select pel.pil_elctbl_chc_popl_id,
3346: pel.object_version_number
3347: from ben_pil_elctbl_chc_popl pel,
3348: ben_per_in_ler pil
3349: where pil.per_in_ler_id = p_per_in_ler_id
3350: and pil.business_group_id = p_business_group_id
3351: and pel.per_in_ler_id = pil.per_in_ler_id

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

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

Line 6479: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then

6475: end loop;
6476: --
6477: close c_ben_bnft_prvdd_ldgr_f;
6478: --
6479: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then
6480:
6481: -- pil popl's are updated to 'backed out'
6482: if nvl(p_copy_only,'N') <> 'Y' then
6483: open c_ben_pil_elctbl_chc_popl;

Line 6483: open c_ben_pil_elctbl_chc_popl;

6479: elsif p_routine = 'BEN_PIL_ELCTBL_CHC_POPL' then
6480:
6481: -- pil popl's are updated to 'backed out'
6482: if nvl(p_copy_only,'N') <> 'Y' then
6483: open c_ben_pil_elctbl_chc_popl;
6484:
6485: loop
6486:
6487: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,

Line 6487: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,

6483: open c_ben_pil_elctbl_chc_popl;
6484:
6485: loop
6486:
6487: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,
6488: l_object_version_number;
6489: exit when c_ben_pil_elctbl_chc_popl%notfound;
6490: --
6491: -- Delete from the appropriate API.

Line 6489: exit when c_ben_pil_elctbl_chc_popl%notfound;

6485: loop
6486:
6487: fetch c_ben_pil_elctbl_chc_popl into l_pk_id,
6488: l_object_version_number;
6489: exit when c_ben_pil_elctbl_chc_popl%notfound;
6490: --
6491: -- Delete from the appropriate API.
6492: --
6493: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

Line 6493: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

6489: exit when c_ben_pil_elctbl_chc_popl%notfound;
6490: --
6491: -- Delete from the appropriate API.
6492: --
6493: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
6494: (p_validate => false,
6495: p_pil_elctbl_chc_popl_id => l_pk_id,
6496: p_pil_elctbl_popl_stat_cd => 'BCKDT',
6497: p_object_version_number => l_object_version_number,

Line 6502: close c_ben_pil_elctbl_chc_popl;

6498: p_effective_date => p_effective_date);
6499:
6500: end loop;
6501:
6502: close c_ben_pil_elctbl_chc_popl;
6503: end if ;
6504: --
6505: elsif p_routine = 'BEN_CBR_QUALD_BNF' then
6506: --

Line 6657: if c_ben_pil_elctbl_chc_popl%isopen then

6653: close c_ben_prtt_enrt_rslt_f;
6654: --
6655: end if;
6656: --
6657: if c_ben_pil_elctbl_chc_popl%isopen then
6658: --
6659: close c_ben_pil_elctbl_chc_popl;
6660: --
6661: end if;

Line 6659: close c_ben_pil_elctbl_chc_popl;

6655: end if;
6656: --
6657: if c_ben_pil_elctbl_chc_popl%isopen then
6658: --
6659: close c_ben_pil_elctbl_chc_popl;
6660: --
6661: end if;
6662: --
6663: raise;