APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_TRGR_F

Line 2690: ben_per_cm_trgr_f c,

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,
2694: ben_ler_f l

Line 2781: from ben_per_cm_trgr_f c

2777: p_effective_date in date
2778: ) is
2779: select c.effective_start_date ,
2780: c.cm_trgr_id
2781: from ben_per_cm_trgr_f c
2782: where p_per_cm_id = c.per_cm_id
2783: and p_effective_date
2784: between c.effective_start_date and c.effective_end_date
2785: ;

Line 2826: l_cm_trgr_id ben_per_cm_trgr_f.cm_trgr_id%type ;

2822: and p_effective_date
2823: between l.effective_start_date and l.effective_end_date
2824: ;
2825:
2826: l_cm_trgr_id ben_per_cm_trgr_f.cm_trgr_id%type ;
2827: l_last_per_cm_prvdd_id number:=null;
2828: l_err_message fnd_new_messages.message_text%type ;
2829: --
2830: /* Start of Changes for WWBUG: 2008949: added cursor */