DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_F

Line 2722: from ben_per_cm_f a,

2718: , l.name
2719: , p.per_in_ler_stat_cd
2720: , nvl(p.lf_evt_ocrd_dt,a.effective_start_date) lf_evt_ocrd_dt
2721: , nvl(p.ntfn_dt,a.effective_start_date) ntfn_dt
2722: from ben_per_cm_f a,
2723: ben_per_cm_prvdd_f b,
2724: ben_per_cm_trgr_f c,
2725: ben_cm_trgr d,
2726: ben_cm_typ_f e,

Line 2793: from ben_per_cm_f a,

2789: , b.address_id
2790: , b.per_cm_prvdd_id
2791: , b.object_version_number
2792: , a.cm_typ_id
2793: from ben_per_cm_f a,
2794: ben_per_cm_prvdd_f b
2795: where
2796: a.person_id = p_person_id
2797: and a.per_cm_id = b.per_cm_id