APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PL_TYP

Line 1658: from ben_pl_typ_f ptp

1654: --
1655: -- Bug : 3866580
1656: cursor c_pl_typ_opt_typ_cd (pl_typ_id number, p_effective_date date) is
1657: select ptp.opt_typ_cd
1658: from ben_pl_typ_f ptp
1659: where ptp.pl_typ_id = p_pl_typ_id
1660: and p_effective_date between ptp.effective_start_date
1661: and ptp.effective_end_date;
1662:

Line 1663: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;

1659: where ptp.pl_typ_id = p_pl_typ_id
1660: and p_effective_date between ptp.effective_start_date
1661: and ptp.effective_end_date;
1662:
1663: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;
1664: -- Bug : 3866580
1665: --
1666: l_pel c_pel%rowtype;
1667: /* End of Changes for Bug: 1646442: added cursor */

Line 3101: from ben_pl_typ_f ptp

3097: --
3098: -- Bug : 3866580
3099: cursor c_pl_typ_opt_typ_cd (pl_typ_id number, p_effective_date date) is
3100: select ptp.opt_typ_cd
3101: from ben_pl_typ_f ptp
3102: where ptp.pl_typ_id = p_pl_typ_id
3103: and p_effective_date between ptp.effective_start_date
3104: and ptp.effective_end_date;
3105:

Line 3106: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;

3102: where ptp.pl_typ_id = p_pl_typ_id
3103: and p_effective_date between ptp.effective_start_date
3104: and ptp.effective_end_date;
3105:
3106: l_pl_typ_opt_typ_cd ben_pl_typ.opt_typ_cd%type;
3107: -- Bug : 3866580
3108: --
3109: --
3110: l_ppe_dt_to_use date;

Line 9825: from ben_pl_typ_f

9821: ;
9822:
9823: cursor c_pl_typ_names(p_acrs_ptip_cvg_id number) is
9824: select name
9825: from ben_pl_typ_f
9826: where pl_typ_id in
9827: ( select pl_typ_id
9828: from ben_ptip_f
9829: where pgm_id = p_pgm_id

Line 10220: from ben_pl_typ_f

10216: l_acrs_ptip c_acrs_ptip%rowtype;
10217: -- bug 3123698
10218: cursor c_pl_typ_names(p_acrs_ptip_cvg_id number) is
10219: select name
10220: from ben_pl_typ_f
10221: where pl_typ_id in
10222: ( select pl_typ_id
10223: from ben_ptip_f
10224: where pgm_id = p_pgm_id