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

Line 99: from ben_pl_typ_f ptp,

95: and p_effective_date between op.effective_start_date and op.effective_end_date;
96:
97: cursor c_pl_typ(p_pl_id number) is
98: select opt_typ_cd
99: from ben_pl_typ_f ptp,
100: ben_pl_f pln
101: where pln.pl_id = p_pl_id
102: and ptp.pl_typ_id = pln.pl_typ_id
103: and p_effective_date between pln.effective_start_date and pln.effective_end_date

Line 106: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;

102: and ptp.pl_typ_id = pln.pl_typ_id
103: and p_effective_date between pln.effective_start_date and pln.effective_end_date
104: and p_effective_date between ptp.effective_start_date and ptp.effective_end_date;
105: --
106: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;
107: l_pl_id number;
108: --End of Code for Bug 6881417
109:
110: --