APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_ACTY_BASE_RT_F

Line 117: from ben_acty_base_rt_f abr

113: abr.comp_lvl_fctr_id,
114: abr.actl_prem_id,
115: abr.input_value_id,
116: abr.element_type_id
117: from ben_acty_base_rt_f abr
118: where abr.pl_id = p_pl_id
119: and abr.acty_typ_cd = 'PRFRFS'
120: and abr.acty_base_rt_stat_cd = 'A'
121: and p_effective_date between

Line 145: from ben_acty_base_rt_f abr,

141: is
142: select prv.prtt_rt_val_id,
143: prv.object_version_number,
144: ecr.enrt_rt_id
145: from ben_acty_base_rt_f abr,
146: ben_prtt_rt_val prv,
147: ben_enrt_rt ecr
148: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
149: and prv.prtt_rt_val_stat_cd is null

Line 382: from ben_acty_base_rt_f abr,

378: l_pl_subj_frfs c_pl_subj_frfs%rowtype;
379: --
380: cursor c_abr (p_effective_date date, p_acty_typ_cd varchar2) is
381: select /* abr.*,*/ clf.* -- 9999 Add the only colums required.
382: from ben_acty_base_rt_f abr,
383: ben_comp_lvl_fctr clf
384: where abr.acty_typ_cd like p_acty_typ_cd || '%'
385: -- p_acty_typ_cd is like PRD/PRC
386: and abr.pl_id = p_pl_id

Line 394: from ben_acty_base_rt_f abr,

390: abr.effective_start_date and abr.effective_end_date;
391: --
392: cursor c_abr_temp (p_effective_date date, p_acty_typ_cd varchar2) is
393: select /* abr.*,*/ clf.* -- 9999 Add the only colums required.
394: from ben_acty_base_rt_f abr,
395: ben_comp_lvl_fctr clf
396: where abr.acty_typ_cd not like 'PRD%'
397: and abr.pl_id = p_pl_id
398: and abr.acty_base_rt_stat_cd = 'A'