APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_COMP_LVL_FCTR

Line 383: ben_comp_lvl_fctr clf

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
387: and abr.acty_base_rt_stat_cd = 'A'

Line 395: ben_comp_lvl_fctr clf

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'
399: and abr.ttl_comp_lvl_fctr_id = clf.comp_lvl_fctr_id