DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_LF_EVT_CLPS_RESTORE

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 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