DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_CWB_PL_DSGN

Line 3036: ben_cwb_pl_dsgn pl

3032: ,pl.ASG_UPDT_EFF_DATE
3033: from ben_cwb_person_info cpi ,
3034: ben_per_in_ler pil ,
3035: ben_ler_f ler ,
3036: ben_cwb_pl_dsgn pl
3037: where cpi.person_id = p_person_id
3038: and cpi.group_per_in_ler_id = pil.per_in_ler_id
3039: and pil.ler_id = ler.ler_id
3040: and pil.group_pl_id = pl.pl_id

Line 3090: from ben_cwb_pl_dsgn pl

3086: ;
3087:
3088: cursor c_pln(p_pl_id number , p_dt date ) is
3089: select name
3090: from ben_cwb_pl_dsgn pl
3091: where p_pl_id = pl.PL_ID
3092: and pl.oipl_id = -1
3093: and p_dt = pl.lf_evt_ocrd_dt
3094: ;