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_MNG_DPNT_BNF dependencies on BEN_MANAGE_LIFE_EVENTS

Line 191: and ( (ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL and ben_lf_evt_clps_restore.g_dflt_during_reinstate = 'N'

187: the dependent*/
188: /*Bug 14119948: When the Coverage code is 'Current can keep or Choose But Start New', prttt_enrt_rslt_id changes,
189: hence while reimstating the enrollments check which dependents should be carry forwarded and when defaults are applied during
190: reinstatement, skip the below cursor checks as above portion of the cursor takes care of which dependents should be carry forwarded*/
191: and ( (ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL and ben_lf_evt_clps_restore.g_dflt_during_reinstate = 'N'
192: and (
193: (l_old_prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id
194: and ('1' = (select '1' from dual where
195: not exists

Line 197: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id

193: (l_old_prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id
194: and ('1' = (select '1' from dual where
195: not exists
196: (select '1' from ben_le_clsn_n_rstr pdp_old
197: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
198: and pdp_old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
199: and pdp_old.business_group_id = p_business_group_id
200: and pdp_old.dpnt_person_id = old.dpnt_person_id
201: and pdp_old.cvg_thru_dt <> hr_api.g_eot

Line 208: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id

204: and ('1' = (select '1' from dual where
205: exists
206: (select '1' from ben_le_clsn_n_rstr pdp_old
207: ,ben_prtt_enrt_rslt_f pen5
208: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
209: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
210: and pdp_old.business_group_id = p_business_group_id
211: and pdp_old.dpnt_person_id = old.dpnt_person_id
212: and pdp_old.cvg_thru_dt = hr_api.g_eot

Line 214: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id

210: and pdp_old.business_group_id = p_business_group_id
211: and pdp_old.dpnt_person_id = old.dpnt_person_id
212: and pdp_old.cvg_thru_dt = hr_api.g_eot
213: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
214: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
215: and pen5.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
216: and pen5.business_group_id = p_business_group_id
217: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id
218: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc

Line 223: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id

219: where elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id)
220: union
221: select '1' from ben_elig_cvrd_dpnt_f pdp_old
222: ,ben_prtt_enrt_rslt_f pen5
223: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
224: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
225: and pdp_old.business_group_id = p_business_group_id
226: and pdp_old.dpnt_person_id = old.dpnt_person_id
227: and pdp_old.cvg_thru_dt = hr_api.g_eot

Line 228: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id

224: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
225: and pdp_old.business_group_id = p_business_group_id
226: and pdp_old.dpnt_person_id = old.dpnt_person_id
227: and pdp_old.cvg_thru_dt = hr_api.g_eot
228: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
229: and pen5.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
230: and pen5.business_group_id = p_business_group_id
231: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id
232: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc

Line 237: ) or (ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL and ben_lf_evt_clps_restore.g_dflt_during_reinstate = 'Y')

233: where elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id) )))
234:
235: )
236: )
237: ) or (ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL and ben_lf_evt_clps_restore.g_dflt_during_reinstate = 'Y')
238: or (ben_manage_life_events.g_bckdt_per_in_ler_id is NULL )
239: )
240: and
241: (pcr.contact_type in

Line 238: or (ben_manage_life_events.g_bckdt_per_in_ler_id is NULL )

234:
235: )
236: )
237: ) or (ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL and ben_lf_evt_clps_restore.g_dflt_during_reinstate = 'Y')
238: or (ben_manage_life_events.g_bckdt_per_in_ler_id is NULL )
239: )
240: and
241: (pcr.contact_type in
242: (select c.rlshp_typ_cd