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.IGS_EN_WORKFLOW dependencies on IGS_LOOKUP_VALUES

Line 1378: CURSOR c_discon_type (cp_discon_rsn_type igs_lookup_values.lookup_code%TYPE) IS

1374: FROM IGS_EN_DCNT_REASONCD
1375: WHERE DISCONTINUATION_REASON_CD = cp_discon_rsn_cd;
1376:
1377: -- Get the description of discontinuation reason type
1378: CURSOR c_discon_type (cp_discon_rsn_type igs_lookup_values.lookup_code%TYPE) IS
1379: SELECT meaning
1380: FROM IGS_LOOKUP_VALUES
1381: WHERE lookup_code = cp_discon_rsn_type
1382: AND lookup_type = 'DISCONTINUATION_REASON_TYPE';

Line 1380: FROM IGS_LOOKUP_VALUES

1376:
1377: -- Get the description of discontinuation reason type
1378: CURSOR c_discon_type (cp_discon_rsn_type igs_lookup_values.lookup_code%TYPE) IS
1379: SELECT meaning
1380: FROM IGS_LOOKUP_VALUES
1381: WHERE lookup_code = cp_discon_rsn_type
1382: AND lookup_type = 'DISCONTINUATION_REASON_TYPE';
1383:
1384: l_c_discon_rsn c_discon_rsn%ROWTYPE;

Line 1389: l_discon_rsn_type igs_lookup_values.lookup_code%TYPE;

1385: l_c_discon_type c_discon_type%ROWTYPE;
1386: l_c_full_name c_full_name%ROWTYPE;
1387:
1388: l_discon_rsn_cd IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE;
1389: l_discon_rsn_type igs_lookup_values.lookup_code%TYPE;
1390:
1391: BEGIN
1392:
1393: