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_PLAN_TYPE_OPTION_TYPE_API dependencies on BEN_PL_TYP_F

Line 79: from ben_pl_typ_f ptp

75: opt.effective_start_date and opt.effective_end_date ;
76:
77: cursor c_ptp is
78: select ptp.opt_typ_cd
79: from ben_pl_typ_f ptp
80: where ptp.pl_typ_id = p_pl_typ_id
81: and p_effective_date between
82: ptp.effective_start_date and ptp.effective_end_date ;
83:

Line 85: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;

81: and p_effective_date between
82: ptp.effective_start_date and ptp.effective_end_date ;
83:
84: l_group_opt_id ben_opt_f.Group_opt_id%type ;
85: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
86: l_opt_ovn number ;
87: l_eff_st_dt date ;
88: l_eff_end_dt date ;
89:

Line 412: from ben_pl_typ_f ptp

408: opt.effective_start_date and opt.effective_end_date ;
409:
410: cursor c_ptp is
411: select ptp.opt_typ_cd
412: from ben_pl_typ_f ptp
413: where ptp.pl_typ_id = p_pl_typ_id
414: and p_effective_date between
415: ptp.effective_start_date and ptp.effective_end_date ;
416:

Line 418: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;

414: and p_effective_date between
415: ptp.effective_start_date and ptp.effective_end_date ;
416:
417: l_group_opt_id ben_opt_f.Group_opt_id%type ;
418: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
419: l_opt_ovn number ;
420: l_eff_st_dt date ;
421: l_eff_end_dt date ;
422: