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_PRTT_PREM_F

Line 105: 12-Oct-99 Tmathers 115.24 removed val form ben_prtt_prem_f

101: per in ler to back out is
102: (bckt_per_in_ler_id) added.
103: 04-Oct-99 Gperry 115.23 Added p_bckt_stat_cd to
104: unprocess_ptnl_ler procedure.
105: 12-Oct-99 Tmathers 115.24 removed val form ben_prtt_prem_f
106: 12-Oct-99 pbodla 115.25 Added code to insert link data
107: between pen and epe into lcr
108: table when the enrt results are
109: deleted.

Line 195: c_ben_prtt_prem_f,

191: from the cursors -
192: c_ben_ELIG_PER_OPT_f,
193: c_epo_max_esd_of_past_pil,
194: c_ben_elig_per_f,
195: c_ben_prtt_prem_f,
196: c_ben_pl_bnf_f,
197: c_ben_prmry_care_prvdr_f
198: 31-AUG-00 jcarpent 115.50 OraBug# 4988. Added logic to
199: cdaniels skip the call to the delete

Line 208: BEN_PRTT_PREM_F

204: Affect p_routines:
205: BEN_ELIG_CVRD_DPNT_F
206: BEN_ELIG_PER_F
207: BEN_ELIG_PER_OPT_F
208: BEN_PRTT_PREM_F
209: BEN_PL_BNF_F
210: BEN_PRTT_ENRT_RSLT_F
211: 14-Sep-2000 jcarpent 115.51 Bug 1269016. added bolfe
212: effective_date global.

Line 1306: -- BEN_PRTT_PREM_F (PPE)

1302: -- BEN_PER_CM_TRGR_F (PCR) (join to pil to check status)
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).

Line 1448: delete_routine(p_routine => 'BEN_PRTT_PREM_F',

1444: p_copy_only => p_copy_only,
1445: p_effective_date => p_effective_date);
1446:
1447: -- mark prtt_prem's 'backed out'
1448: delete_routine(p_routine => 'BEN_PRTT_PREM_F',
1449: p_per_in_ler_id => p_per_in_ler_id,
1450: p_business_group_id => p_business_group_id,
1451: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1452: p_copy_only => p_copy_only,

Line 2091: from ben_prtt_prem_f

2087: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
2088: --
2089: cursor c_check_prem_active is
2090: select 1
2091: from ben_prtt_prem_f
2092: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2093: and effective_end_date = hr_api.g_eot;
2094: l_check_prem_active c_check_prem_active%rowtype;
2095: --

Line 2098: from ben_prtt_prem_f ppm

2094: l_check_prem_active c_check_prem_active%rowtype;
2095: --
2096: cursor c_ended_prem_details is
2097: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
2098: from ben_prtt_prem_f ppm
2099: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2100: and ppm.effective_end_date <> hr_api.g_eot
2101: and not exists (select 1
2102: from ben_prtt_prem_f ppm2

Line 2102: from ben_prtt_prem_f ppm2

2098: from ben_prtt_prem_f ppm
2099: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2100: and ppm.effective_end_date <> hr_api.g_eot
2101: and not exists (select 1
2102: from ben_prtt_prem_f ppm2
2103: where ppm2.prtt_prem_id = ppm.prtt_prem_id
2104: and ppm2.effective_end_date > ppm.effective_end_date)
2105: order by effective_start_date desc;
2106: l_ended_prem_details c_ended_prem_details%rowtype;

Line 2590: -- START ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F

2586: and business_group_id = p_business_group_id
2587: and effective_end_date > v_effective_date;
2588: --
2589: -- END ----> DELETE ROUTINE FOR BEN_ELIG_PER_F
2590: -- START ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F
2591: --
2592: -- Source Table
2593: -- BEN_PER_IN_LER
2594: --

Line 2596: cursor c_ben_prtt_prem_f_corr is

2592: -- Source Table
2593: -- BEN_PER_IN_LER
2594: --
2595: ----7133998
2596: cursor c_ben_prtt_prem_f_corr is
2597: select ppe.*
2598: from ben_prtt_prem_f ppe,
2599: ben_per_in_ler pil,
2600: BEN_LE_CLSN_N_RSTR bkup

Line 2598: from ben_prtt_prem_f ppe,

2594: --
2595: ----7133998
2596: cursor c_ben_prtt_prem_f_corr is
2597: select ppe.*
2598: from ben_prtt_prem_f ppe,
2599: ben_per_in_ler pil,
2600: BEN_LE_CLSN_N_RSTR bkup
2601: where pil.per_in_ler_id = p_per_in_ler_id
2602: and pil.business_group_id = p_business_group_id

Line 2608: AND bkup.BKUP_TBL_TYP_CD = 'BEN_PRTT_PREM_F_CORR'

2604: and ppe.business_group_id = pil.business_group_id
2605: and (p_bckdt_prtt_enrt_rslt_id is null
2606: or p_bckdt_prtt_enrt_rslt_id = ppe.prtt_enrt_rslt_id
2607: )
2608: AND bkup.BKUP_TBL_TYP_CD = 'BEN_PRTT_PREM_F_CORR'
2609: AND bkup.BKUP_TBL_ID = ppe.prtt_prem_id
2610: and bkup.effective_start_date = ppe.effective_start_date
2611: and bkup.effective_end_date = ppe.effective_end_date
2612: and bkup.per_in_ler_ended_id = pil.per_in_ler_id;

Line 2627: cursor c_ben_prtt_prem_f is

2623: and effective_end_date = cv_effective_end_date
2624: and per_in_ler_ended_id = p_per_in_ler_id
2625: order by effective_start_date;
2626: --------7133998
2627: cursor c_ben_prtt_prem_f is
2628: select ppe.prtt_prem_id,
2629: ppe.object_version_number
2630: from ben_prtt_prem_f ppe,
2631: ben_per_in_ler pil

Line 2630: from ben_prtt_prem_f ppe,

2626: --------7133998
2627: cursor c_ben_prtt_prem_f is
2628: select ppe.prtt_prem_id,
2629: ppe.object_version_number
2630: from ben_prtt_prem_f ppe,
2631: ben_per_in_ler pil
2632: where pil.per_in_ler_id = p_per_in_ler_id
2633: and pil.business_group_id = p_business_group_id
2634: and ppe.per_in_ler_id = pil.per_in_ler_id

Line 2657: from ben_prtt_prem_f

2653: --
2654: /*
2655: cursor c_ppe_max_esd_of_past_pil(v_prtt_prem_id in number) is
2656: select max(effective_end_date), max(object_version_number)
2657: from ben_prtt_prem_f
2658: where prtt_prem_id = v_prtt_prem_id
2659: and nvl(per_in_ler_id , -1) <> p_per_in_ler_id
2660: and business_group_id = p_business_group_id;
2661: -- and effective_end_date < p_effective_date;

Line 2665: from ben_prtt_prem_f prm,

2661: -- and effective_end_date < p_effective_date;
2662: */
2663: cursor c_ppe_max_esd_of_past_pil(v_prtt_prem_id in number) is
2664: select prm.effective_end_date, prm.object_version_number
2665: from ben_prtt_prem_f prm,
2666: ben_per_in_ler pil
2667: where prm.prtt_prem_id = v_prtt_prem_id
2668: and nvl(prm.per_in_ler_id , -1) <> p_per_in_ler_id
2669: and prm.business_group_id = p_business_group_id

Line 2678: from ben_prtt_prem_f

2674:
2675: cursor c_deleted_ppe(v_prtt_prem_id in number,
2676: v_effective_date in date) is
2677: select *
2678: from ben_prtt_prem_f
2679: where prtt_prem_id = v_prtt_prem_id
2680: and nvl(per_in_ler_id , -1) = p_per_in_ler_id
2681: and business_group_id = p_business_group_id
2682: and effective_end_date > v_effective_date;

Line 2685: -- END ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F

2681: and business_group_id = p_business_group_id
2682: and effective_end_date > v_effective_date;
2683:
2684: --
2685: -- END ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F
2686: --
2687: -- START ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F
2688: --
2689: -- Source Table

Line 4457: elsif p_routine = 'BEN_PRTT_PREM_F' then

4453: --
4454:
4455: close c_ben_elig_per_opt_f;
4456: --
4457: elsif p_routine = 'BEN_PRTT_PREM_F' then
4458: -------------Bug 7133998
4459: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4460: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4461: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);

Line 4459: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop

4455: close c_ben_elig_per_opt_f;
4456: --
4457: elsif p_routine = 'BEN_PRTT_PREM_F' then
4458: -------------Bug 7133998
4459: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4460: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4461: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4462: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4463: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',

Line 4463: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',

4459: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4460: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4461: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4462: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4463: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',
4464: l_prtt_prem_corr.PRTT_PREM_ID,
4465: l_prtt_prem_corr.effective_start_date,
4466: l_prtt_prem_corr.effective_end_date) loop
4467: hr_utility.set_location('ESD,in loop : '||l_prtt_prem_corr.effective_start_date,1);

Line 4500: open c_ben_prtt_prem_f;

4496:
4497: l_prev_pk_id := -1; -- like null
4498:
4499: --
4500: open c_ben_prtt_prem_f;
4501: --
4502: loop
4503: --
4504: fetch c_ben_prtt_prem_f into l_pk_id,

Line 4504: fetch c_ben_prtt_prem_f into l_pk_id,

4500: open c_ben_prtt_prem_f;
4501: --
4502: loop
4503: --
4504: fetch c_ben_prtt_prem_f into l_pk_id,
4505: l_object_version_number;
4506: exit when c_ben_prtt_prem_f%notfound;
4507: --
4508: -- Get the maximum of effective end date for the dependents

Line 4506: exit when c_ben_prtt_prem_f%notfound;

4502: loop
4503: --
4504: fetch c_ben_prtt_prem_f into l_pk_id,
4505: l_object_version_number;
4506: exit when c_ben_prtt_prem_f%notfound;
4507: --
4508: -- Get the maximum of effective end date for the dependents
4509: -- with past per_in_ler 's.
4510: --

Line 4533: open c_bkp_row('BEN_PRTT_PREM_F',

4529: --
4530: for l_deleted_ppe_rec in c_deleted_ppe(l_pk_id, l_effective_date)
4531: loop
4532: --
4533: open c_bkp_row('BEN_PRTT_PREM_F',
4534: l_deleted_ppe_rec.per_in_ler_id,
4535: l_deleted_ppe_rec.PRTT_PREM_ID,
4536: l_deleted_ppe_rec.object_version_number);
4537: fetch c_bkp_row into l_row_id;

Line 4598: 'BEN_PRTT_PREM_F',

4594: LCR_ATTRIBUTE4,
4595: LCR_ATTRIBUTE5
4596: )
4597: values (
4598: 'BEN_PRTT_PREM_F',
4599: l_deleted_ppe_rec.PPE_ATTRIBUTE6,
4600: l_deleted_ppe_rec.PPE_ATTRIBUTE7,
4601: l_deleted_ppe_rec.PPE_ATTRIBUTE8,
4602: l_deleted_ppe_rec.PPE_ATTRIBUTE9,

Line 4741: close c_ben_prtt_prem_f;

4737: --
4738: l_prev_pk_id := -1;
4739: --
4740:
4741: close c_ben_prtt_prem_f;
4742: --
4743: elsif p_routine = 'BEN_PL_BNF_F' then
4744:
4745:

Line 6621: if c_ben_prtt_prem_f%isopen then

6617: close c_ben_elig_per_opt_f;
6618: --
6619: end if;
6620: --
6621: if c_ben_prtt_prem_f%isopen then
6622: --
6623: close c_ben_prtt_prem_f;
6624: --
6625: end if;

Line 6623: close c_ben_prtt_prem_f;

6619: end if;
6620: --
6621: if c_ben_prtt_prem_f%isopen then
6622: --
6623: close c_ben_prtt_prem_f;
6624: --
6625: end if;
6626: --
6627: if c_ben_pl_bnf_f%isopen then