APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_PRVDD_F

Line 2723: ben_per_cm_prvdd_f b,

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

Line 2794: ben_per_cm_prvdd_f b

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

Line 4241: -- updating ben_per_cm_prvdd_f.sent_dt

4237: g_trans_num := g_trans_num + 1;
4238: --
4239: END IF; -- l_include = 'Y'
4240: --
4241: -- updating ben_per_cm_prvdd_f.sent_dt
4242: --
4243: if (ben_ext_person.g_cm_flag = 'Y' and
4244: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4245: ben_ext_person.g_per_cm_prvdd_id is not null and