DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_LE_CLSN_N_RSTR

Line 196: (select '1' from ben_le_clsn_n_rstr pdp_old

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

Line 206: (select '1' from ben_le_clsn_n_rstr pdp_old

202: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'))))
203: or (l_old_prtt_enrt_rslt_id <> p_new_prtt_enrt_rslt_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