DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_CWB_PL_DSGN

Line 3002: ben_cwb_pl_dsgn pl

2998: ,pl.ASG_UPDT_EFF_DATE
2999: from ben_cwb_person_info cpi ,
3000: ben_per_in_ler pil ,
3001: ben_ler_f ler ,
3002: ben_cwb_pl_dsgn pl
3003: where cpi.person_id = p_person_id
3004: and cpi.group_per_in_ler_id = pil.per_in_ler_id
3005: and pil.ler_id = ler.ler_id
3006: and pil.group_pl_id = pl.pl_id

Line 3056: from ben_cwb_pl_dsgn pl

3052: ;
3053:
3054: cursor c_pln(p_pl_id number , p_dt date ) is
3055: select name
3056: from ben_cwb_pl_dsgn pl
3057: where p_pl_id = pl.PL_ID
3058: and pl.oipl_id = -1
3059: and p_dt = pl.lf_evt_ocrd_dt
3060: ;