APPS.BEN_EXT_PERSON dependencies on BEN_PER_CM_TRGR_F

Line 2724: ben_per_cm_trgr_f c,

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

Line 2815: from ben_per_cm_trgr_f c

2811: p_effective_date in date
2812: ) is
2813: select c.effective_start_date ,
2814: c.cm_trgr_id
2815: from ben_per_cm_trgr_f c
2816: where p_per_cm_id = c.per_cm_id
2817: and p_effective_date
2818: between c.effective_start_date and c.effective_end_date
2819: ;

Line 2860: l_cm_trgr_id ben_per_cm_trgr_f.cm_trgr_id%type ;

2856: and p_effective_date
2857: between l.effective_start_date and l.effective_end_date
2858: ;
2859:
2860: l_cm_trgr_id ben_per_cm_trgr_f.cm_trgr_id%type ;
2861: l_last_per_cm_prvdd_id number:=null;
2862: l_err_message fnd_new_messages.message_text%type ;
2863: --
2864: /* Start of Changes for WWBUG: 2008949: added cursor */