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.AHL_FMP_PROGTYPE_SUBTYPE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 265: FROM FND_LOOKUP_VALUES_VL

261: as
262: CURSOR get_lookup_type_code(c_lookup_code VARCHAR2,c_lookup_type VARCHAR2)
263: IS
264: SELECT lookup_code
265: FROM FND_LOOKUP_VALUES_VL
266: WHERE lookup_code = c_lookup_code
267: AND lookup_type = c_lookup_type
268: AND sysdate between start_date_active
269: AND nvl(end_date_active,sysdate);

Line 274: FROM FND_LOOKUP_VALUES_VL

270:
271: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
272: IS
273: SELECT lookup_code
274: FROM FND_LOOKUP_VALUES_VL
275: WHERE lookup_type= c_lookup_type
276: AND upper(meaning) =upper(c_meaning)
277: AND sysdate between start_date_active
278: AND nvl(end_date_active,sysdate);