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_MR_HEADER_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 612: FROM FND_LOOKUP_VALUES_VL

608: as
609: CURSOR get_lookup_type_code(c_lookup_code VARCHAR2,c_lookup_type VARCHAR2)
610: IS
611: SELECT lookup_code
612: FROM FND_LOOKUP_VALUES_VL
613: WHERE lookup_code = c_lookup_code
614: AND lookup_type = c_lookup_type
615: AND sysdate between nvl(start_date_active,sysdate)
616: AND nvl(end_date_active,sysdate)

Line 655: FROM FND_LOOKUP_VALUES_VL

651: as
652: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
653: IS
654: SELECT lookup_code
655: FROM FND_LOOKUP_VALUES_VL
656: WHERE lookup_type= c_lookup_type
657: AND upper(meaning) =upper(c_meaning)
658: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);
659:

Line 1160: FROM FND_LOOKUP_VALUES_VL

1156:
1157: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
1158: IS
1159: SELECT lookup_code
1160: FROM FND_LOOKUP_VALUES_VL
1161: WHERE lookup_type= c_lookup_type
1162: AND upper(meaning) =upper(c_meaning)
1163: AND sysdate between start_date_active
1164: AND nvl(end_date_active,sysdate);