APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PL_TYP

Line 1731: from ben_pl_typ_f ptp

1727: --
1728: -- Bug : 3866580
1729: cursor c_pl_typ_opt_typ_cd (pl_typ_id number, p_effective_date date) is
1730: select ptp.opt_typ_cd
1731: from ben_pl_typ_f ptp
1732: where ptp.pl_typ_id = p_pl_typ_id
1733: and p_effective_date between ptp.effective_start_date
1734: and ptp.effective_end_date;
1735:

Line 1736: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;

1732: where ptp.pl_typ_id = p_pl_typ_id
1733: and p_effective_date between ptp.effective_start_date
1734: and ptp.effective_end_date;
1735:
1736: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;
1737: -- Bug : 3866580
1738: --
1739: l_pel c_pel%rowtype;
1740: /* End of Changes for Bug: 1646442: added cursor */

Line 3290: from ben_pl_typ_f ptp

3286: --
3287: -- Bug : 3866580
3288: cursor c_pl_typ_opt_typ_cd (pl_typ_id number, p_effective_date date) is
3289: select ptp.opt_typ_cd
3290: from ben_pl_typ_f ptp
3291: where ptp.pl_typ_id = p_pl_typ_id
3292: and p_effective_date between ptp.effective_start_date
3293: and ptp.effective_end_date;
3294:

Line 3295: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;

3291: where ptp.pl_typ_id = p_pl_typ_id
3292: and p_effective_date between ptp.effective_start_date
3293: and ptp.effective_end_date;
3294:
3295: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;
3296: -- Bug : 3866580
3297: --
3298: --
3299: l_ppe_dt_to_use date;

Line 11423: from ben_pl_typ_f

11419: ;
11420:
11421: cursor c_pl_typ_names(p_acrs_ptip_cvg_id number) is
11422: select name
11423: from ben_pl_typ_f
11424: where pl_typ_id in
11425: ( select pl_typ_id
11426: from ben_ptip_f
11427: where pgm_id = p_pgm_id

Line 11818: from ben_pl_typ_f

11814: l_acrs_ptip c_acrs_ptip%rowtype;
11815: -- bug 3123698
11816: cursor c_pl_typ_names(p_acrs_ptip_cvg_id number) is
11817: select name
11818: from ben_pl_typ_f
11819: where pl_typ_id in
11820: ( select pl_typ_id
11821: from ben_ptip_f
11822: where pgm_id = p_pgm_id