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_COMMON_PVT dependencies on CSI_LOOKUPS

Line 2152: select lookup_code from csi_lookups

2148: l_location_type_code VARCHAR2(30);
2149:
2150: CURSOR get_rec_from_value ( c_location VARCHAR2 )
2151: IS
2152: select lookup_code from csi_lookups
2153: where lookup_type='CSI_INST_LOCATION_SOURCE_CODE'
2154: and upper(meaning) like upper(c_location);
2155:
2156: CURSOR get_rec_from_id ( c_location_type_code VARCHAR2 )

Line 2158: select lookup_code from csi_lookups

2154: and upper(meaning) like upper(c_location);
2155:
2156: CURSOR get_rec_from_id ( c_location_type_code VARCHAR2 )
2157: IS
2158: select lookup_code from csi_lookups
2159: where lookup_type='CSI_INST_LOCATION_SOURCE_CODE'
2160: and lookup_code = c_location_type_code;
2161:
2162: BEGIN