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;