DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_F

Line 2688: from ben_per_cm_f a,

2684: , l.name
2685: , p.per_in_ler_stat_cd
2686: , nvl(p.lf_evt_ocrd_dt,a.effective_start_date) lf_evt_ocrd_dt
2687: , nvl(p.ntfn_dt,a.effective_start_date) ntfn_dt
2688: from ben_per_cm_f a,
2689: ben_per_cm_prvdd_f b,
2690: ben_per_cm_trgr_f c,
2691: ben_cm_trgr d,
2692: ben_cm_typ_f e,

Line 2759: from ben_per_cm_f a,

2755: , b.address_id
2756: , b.per_cm_prvdd_id
2757: , b.object_version_number
2758: , a.cm_typ_id
2759: from ben_per_cm_f a,
2760: ben_per_cm_prvdd_f b
2761: where
2762: a.person_id = p_person_id
2763: and a.per_cm_id = b.per_cm_id