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.OKL_VCR_PVT dependencies on FND_LOOKUPS

Line 596: FROM fnd_lookups

592: p_change_type_code IN VARCHAR2) IS
593: -- sjalasut added cursor to validate the change type code
594: CURSOR c_valid_change_csr IS
595: SELECT 'X'
596: FROM fnd_lookups
597: WHERE lookup_type = 'OKL_VP_CHANGE_REQUEST_TYPES'
598: AND lookup_code = p_change_type_code;
599: lv_dummy VARCHAR2(1);
600: BEGIN

Line 639: FROM fnd_lookups

635: p_status_code IN VARCHAR2) IS
636: -- sjalasut added cursor to validate the change type code
637: CURSOR c_valid_status_csr IS
638: SELECT 'X'
639: FROM fnd_lookups
640: WHERE lookup_type = 'OKL_VP_CR_STATUS_CODE'
641: AND lookup_code = p_status_code;
642: lv_dummy VARCHAR2(1);
643: BEGIN