APPS.IGS_AD_GEN_013 dependencies on IGS_AD_CODE_CLASSES
Line 327: FROM igs_ad_code_classes
323:
324: -- Cursor to get the fee type
325: CURSOR cur_sys_stat IS
326: SELECT system_status 327: FROM igs_ad_code_classes 328: WHERE name = p_name
329: AND class = p_class
330: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
331:
Line 332: l_sys_stat igs_ad_code_classes.system_status%TYPE;
328: WHERE name = p_name
329: AND class = p_class
330: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
331: 332: l_sys_stat igs_ad_code_classes.system_status%TYPE; 333: BEGIN
334: --initialise l_sys_stat
335: l_sys_stat := NULL;
336: OPEN cur_sys_stat;