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 1654: -- BEN_PRTT_PREM_F (PPE)

1650: -- BEN_PER_CM_TRGR_F (PCR) (join to pil to check status)
1651: -- BEN_PER_CM_PRVDD_F (PCD) (join to pil to check status)
1652: -- PAY_ELEMENT_ENTRIES_F (PEE)
1653: -- PAY_ELEMENT_ENTRY_VALUES_F (PEV)
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).

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

1792: p_copy_only => p_copy_only,
1793: p_effective_date => p_effective_date);
1794:
1795: -- mark prtt_prem's 'backed out'
1796: delete_routine(p_routine => 'BEN_PRTT_PREM_F',
1797: p_per_in_ler_id => p_per_in_ler_id,
1798: p_business_group_id => p_business_group_id,
1799: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1800: p_copy_only => p_copy_only,

Line 2476: from ben_prtt_prem_f

2472: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
2473: --
2474: cursor c_check_prem_active is
2475: select 1
2476: from ben_prtt_prem_f
2477: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2478: and effective_end_date = hr_api.g_eot;
2479: l_check_prem_active c_check_prem_active%rowtype;
2480: --

Line 2483: from ben_prtt_prem_f ppm

2479: l_check_prem_active c_check_prem_active%rowtype;
2480: --
2481: cursor c_ended_prem_details is
2482: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
2483: from ben_prtt_prem_f ppm
2484: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2485: and ppm.effective_end_date <> hr_api.g_eot
2486: and not exists (select 1
2487: from ben_prtt_prem_f ppm2

Line 2487: from ben_prtt_prem_f ppm2

2483: from ben_prtt_prem_f ppm
2484: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2485: and ppm.effective_end_date <> hr_api.g_eot
2486: and not exists (select 1
2487: from ben_prtt_prem_f ppm2
2488: where ppm2.prtt_prem_id = ppm.prtt_prem_id
2489: and ppm2.effective_end_date > ppm.effective_end_date)
2490: order by effective_start_date desc;
2491: l_ended_prem_details c_ended_prem_details%rowtype;

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

2992: and business_group_id = p_business_group_id
2993: and effective_end_date > v_effective_date;
2994: --
2995: -- END ----> DELETE ROUTINE FOR BEN_ELIG_PER_F
2996: -- START ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F
2997: --
2998: -- Source Table
2999: -- BEN_PER_IN_LER
3000: --

Line 3002: cursor c_ben_prtt_prem_f_corr is

2998: -- Source Table
2999: -- BEN_PER_IN_LER
3000: --
3001: ----7133998
3002: cursor c_ben_prtt_prem_f_corr is
3003: select ppe.*
3004: from ben_prtt_prem_f ppe,
3005: ben_per_in_ler pil,
3006: BEN_LE_CLSN_N_RSTR bkup

Line 3004: from ben_prtt_prem_f ppe,

3000: --
3001: ----7133998
3002: cursor c_ben_prtt_prem_f_corr is
3003: select ppe.*
3004: from ben_prtt_prem_f ppe,
3005: ben_per_in_ler pil,
3006: BEN_LE_CLSN_N_RSTR bkup
3007: where pil.per_in_ler_id = p_per_in_ler_id
3008: and pil.business_group_id = p_business_group_id

Line 3014: AND bkup.BKUP_TBL_TYP_CD = 'BEN_PRTT_PREM_F_CORR'

3010: and ppe.business_group_id = pil.business_group_id
3011: and (p_bckdt_prtt_enrt_rslt_id is null
3012: or p_bckdt_prtt_enrt_rslt_id = ppe.prtt_enrt_rslt_id
3013: )
3014: AND bkup.BKUP_TBL_TYP_CD = 'BEN_PRTT_PREM_F_CORR'
3015: AND bkup.BKUP_TBL_ID = ppe.prtt_prem_id
3016: and bkup.effective_start_date = ppe.effective_start_date
3017: and bkup.effective_end_date = ppe.effective_end_date
3018: and bkup.per_in_ler_ended_id = pil.per_in_ler_id;

Line 3033: cursor c_ben_prtt_prem_f is

3029: and effective_end_date = cv_effective_end_date
3030: and per_in_ler_ended_id = p_per_in_ler_id
3031: order by effective_start_date;
3032: --------7133998
3033: cursor c_ben_prtt_prem_f is
3034: select ppe.prtt_prem_id,
3035: ppe.object_version_number
3036: from ben_prtt_prem_f ppe,
3037: ben_per_in_ler pil

Line 3036: from ben_prtt_prem_f ppe,

3032: --------7133998
3033: cursor c_ben_prtt_prem_f is
3034: select ppe.prtt_prem_id,
3035: ppe.object_version_number
3036: from ben_prtt_prem_f ppe,
3037: ben_per_in_ler pil
3038: where pil.per_in_ler_id = p_per_in_ler_id
3039: and pil.business_group_id = p_business_group_id
3040: and ppe.per_in_ler_id = pil.per_in_ler_id

Line 3063: from ben_prtt_prem_f

3059: --
3060: /*
3061: cursor c_ppe_max_esd_of_past_pil(v_prtt_prem_id in number) is
3062: select max(effective_end_date), max(object_version_number)
3063: from ben_prtt_prem_f
3064: where prtt_prem_id = v_prtt_prem_id
3065: and nvl(per_in_ler_id , -1) <> p_per_in_ler_id
3066: and business_group_id = p_business_group_id;
3067: -- and effective_end_date < p_effective_date;

Line 3071: from ben_prtt_prem_f prm,

3067: -- and effective_end_date < p_effective_date;
3068: */
3069: cursor c_ppe_max_esd_of_past_pil(v_prtt_prem_id in number) is
3070: select prm.effective_end_date, prm.object_version_number
3071: from ben_prtt_prem_f prm,
3072: ben_per_in_ler pil
3073: where prm.prtt_prem_id = v_prtt_prem_id
3074: and nvl(prm.per_in_ler_id , -1) <> p_per_in_ler_id
3075: and prm.business_group_id = p_business_group_id

Line 3084: from ben_prtt_prem_f

3080:
3081: cursor c_deleted_ppe(v_prtt_prem_id in number,
3082: v_effective_date in date) is
3083: select *
3084: from ben_prtt_prem_f
3085: where prtt_prem_id = v_prtt_prem_id
3086: and nvl(per_in_ler_id , -1) = p_per_in_ler_id
3087: and business_group_id = p_business_group_id
3088: and effective_end_date > v_effective_date;

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

3087: and business_group_id = p_business_group_id
3088: and effective_end_date > v_effective_date;
3089:
3090: --
3091: -- END ----> DELETE ROUTINE FOR BEN_PRTT_PREM_F
3092: --
3093: -- START ----> DELETE ROUTINE FOR BEN_ELIG_CVRD_DPNT_F
3094: --
3095: -- Source Table

Line 4939: elsif p_routine = 'BEN_PRTT_PREM_F' then

4935: --
4936:
4937: close c_ben_elig_per_opt_f;
4938: --
4939: elsif p_routine = 'BEN_PRTT_PREM_F' then
4940: -------------Bug 7133998
4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);

Line 4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop

4937: close c_ben_elig_per_opt_f;
4938: --
4939: elsif p_routine = 'BEN_PRTT_PREM_F' then
4940: -------------Bug 7133998
4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4944: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4945: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',

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

4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4944: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4945: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',
4946: l_prtt_prem_corr.PRTT_PREM_ID,
4947: l_prtt_prem_corr.effective_start_date,
4948: l_prtt_prem_corr.effective_end_date) loop
4949: hr_utility.set_location('ESD,in loop : '||l_prtt_prem_corr.effective_start_date,1);

Line 4982: open c_ben_prtt_prem_f;

4978:
4979: l_prev_pk_id := -1; -- like null
4980:
4981: --
4982: open c_ben_prtt_prem_f;
4983: --
4984: loop
4985: --
4986: fetch c_ben_prtt_prem_f into l_pk_id,

Line 4986: fetch c_ben_prtt_prem_f into l_pk_id,

4982: open c_ben_prtt_prem_f;
4983: --
4984: loop
4985: --
4986: fetch c_ben_prtt_prem_f into l_pk_id,
4987: l_object_version_number;
4988: exit when c_ben_prtt_prem_f%notfound;
4989: --
4990: -- Get the maximum of effective end date for the dependents

Line 4988: exit when c_ben_prtt_prem_f%notfound;

4984: loop
4985: --
4986: fetch c_ben_prtt_prem_f into l_pk_id,
4987: l_object_version_number;
4988: exit when c_ben_prtt_prem_f%notfound;
4989: --
4990: -- Get the maximum of effective end date for the dependents
4991: -- with past per_in_ler 's.
4992: --

Line 5015: open c_bkp_row('BEN_PRTT_PREM_F',

5011: --
5012: for l_deleted_ppe_rec in c_deleted_ppe(l_pk_id, l_effective_date)
5013: loop
5014: --
5015: open c_bkp_row('BEN_PRTT_PREM_F',
5016: l_deleted_ppe_rec.per_in_ler_id,
5017: l_deleted_ppe_rec.PRTT_PREM_ID,
5018: l_deleted_ppe_rec.object_version_number);
5019: fetch c_bkp_row into l_row_id;

Line 5080: 'BEN_PRTT_PREM_F',

5076: LCR_ATTRIBUTE4,
5077: LCR_ATTRIBUTE5
5078: )
5079: values (
5080: 'BEN_PRTT_PREM_F',
5081: l_deleted_ppe_rec.PPE_ATTRIBUTE6,
5082: l_deleted_ppe_rec.PPE_ATTRIBUTE7,
5083: l_deleted_ppe_rec.PPE_ATTRIBUTE8,
5084: l_deleted_ppe_rec.PPE_ATTRIBUTE9,

Line 5223: close c_ben_prtt_prem_f;

5219: --
5220: l_prev_pk_id := -1;
5221: --
5222:
5223: close c_ben_prtt_prem_f;
5224: --
5225: elsif p_routine = 'BEN_PL_BNF_F' then
5226:
5227:

Line 7273: if c_ben_prtt_prem_f%isopen then

7269: close c_ben_elig_per_opt_f;
7270: --
7271: end if;
7272: --
7273: if c_ben_prtt_prem_f%isopen then
7274: --
7275: close c_ben_prtt_prem_f;
7276: --
7277: end if;

Line 7275: close c_ben_prtt_prem_f;

7271: end if;
7272: --
7273: if c_ben_prtt_prem_f%isopen then
7274: --
7275: close c_ben_prtt_prem_f;
7276: --
7277: end if;
7278: --
7279: if c_ben_pl_bnf_f%isopen then