eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PL_TYP_F

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 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 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