APPS.IGS_AD_GEN_002 dependencies on IGS_AD_CODE_CLASSES

Line 3011: CURSOR c_appl_fee_status_meaning (p_sys_fee_status igs_ad_code_classes.class%TYPE) IS

3007: SELECT appl_fee_amt
3008: FROM igs_ad_appl_all
3009: WHERE person_id = p_person_id
3010: AND admission_appl_number = p_admission_appl_number;
3011: CURSOR c_appl_fee_status_meaning (p_sys_fee_status igs_ad_code_classes.class%TYPE) IS
3012: SELECT meaning
3013: FROM igs_lookup_values
3014: WHERE lookup_type = 'SYS_FEE_STATUS'
3015: AND lookup_code = p_sys_fee_status;

Line 3020: igs_ad_code_classes cc

3016: CURSOR c_fee_amount IS
3017: SELECT req.fee_amount,
3018: cc.system_status fee_status
3019: FROM igs_ad_app_req req,
3020: igs_ad_code_classes cc
3021: WHERE req.person_id = p_person_id
3022: AND req.admission_appl_number = p_admission_appl_number
3023: AND cc.CLASS = 'SYS_FEE_STATUS'
3024: AND cc.CODE_ID = req.applicant_fee_status

Line 3026: FROM igs_ad_code_classes

3022: AND req.admission_appl_number = p_admission_appl_number
3023: AND cc.CLASS = 'SYS_FEE_STATUS'
3024: AND cc.CODE_ID = req.applicant_fee_status
3025: AND EXISTS (SELECT 'x'
3026: FROM igs_ad_code_classes
3027: WHERE class = 'SYS_FEE_TYPE'
3028: AND system_status = 'APPL_FEE'
3029: AND req.applicant_fee_type = code_id)
3030: ORDER BY req.fee_date;