DBA Data[Home] [Help]

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_ACTY_BASE_RT_F

Line 474: from ben_acty_base_rt_f

470: l_outputs ff_exec.outputs_t;
471:
472: cursor c_abr is
473: select element_det_rl
474: from ben_acty_base_rt_f
475: where acty_base_rt_id = p_acty_base_rt_id
476: and p_effective_date between effective_start_date
477: and effective_end_date;
478:

Line 4775: from ben_acty_base_rt_f abr

4771: and cv_lf_evt_ocrd_dt between oipl.effective_start_date
4772: and oipl.effective_end_date
4773: and exists
4774: (select null
4775: from ben_acty_base_rt_f abr
4776: where abr.pl_id = cv_pl_id
4777: and cv_lf_evt_ocrd_dt between abr.effective_start_date
4778: and abr.effective_end_date
4779: and abr.acty_typ_cd = 'CWBWS' -- 9999