APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_PRVDD_F

Line 2689: ben_per_cm_prvdd_f b,

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,
2693: ben_per_in_ler p,

Line 2760: ben_per_cm_prvdd_f b

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
2764: and b.per_cm_prvdd_stat_cd = 'ACTIVE' -- this should be inclusion criteria.

Line 4206: -- updating ben_per_cm_prvdd_f.sent_dt

4202: g_trans_num := g_trans_num + 1;
4203: --
4204: END IF; -- l_include = 'Y'
4205: --
4206: -- updating ben_per_cm_prvdd_f.sent_dt
4207: --
4208: if (ben_ext_person.g_cm_flag = 'Y' and
4209: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4210: ben_ext_person.g_per_cm_prvdd_id is not null and