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 576: FROM FND_LOOKUP_VALUES_VL

572: as
573: CURSOR get_lookup_type_code(c_lookup_code VARCHAR2,c_lookup_type VARCHAR2)
574: IS
575: SELECT lookup_code
576: FROM FND_LOOKUP_VALUES_VL
577: WHERE lookup_code = c_lookup_code
578: AND lookup_type = c_lookup_type
579: AND sysdate between nvl(start_date_active,sysdate)
580: AND nvl(end_date_active,sysdate);

Line 602: FROM FND_LOOKUP_VALUES_VL

598: as
599: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
600: IS
601: SELECT lookup_code
602: FROM FND_LOOKUP_VALUES_VL
603: WHERE lookup_type= c_lookup_type
604: AND upper(meaning) =upper(c_meaning)
605: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);
606:

Line 1030: FROM FND_LOOKUP_VALUES_VL

1026:
1027: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
1028: IS
1029: SELECT lookup_code
1030: FROM FND_LOOKUP_VALUES_VL
1031: WHERE lookup_type= c_lookup_type
1032: AND upper(meaning) =upper(c_meaning)
1033: AND sysdate between start_date_active
1034: AND nvl(end_date_active,sysdate);