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,
2694: ben_ler_f l
2695: where
Line 2793: from ben_cm_trgr d
2789: cursor c_comm_trgr (
2790: p_cm_trgr_id in number
2791: ) is
2792: select d.proc_cd 2793: from ben_cm_trgr d 2794: where p_cm_trgr_id = d.cm_trgr_id ;
2795:
2796:
2797: cursor c_comm_typ (