APPS.IGS_AD_GEN_015 dependencies on IGS_LOOKUPS_VIEW

Line 90: l_fee_payment_method igs_lookups_view.lookup_code%TYPE;

86: AND sat.admission_application_type = aa.application_type;
87:
88: c_en_deposit_amt_rec c_en_deposit_amt%ROWTYPE;
89:
90: l_fee_payment_method igs_lookups_view.lookup_code%TYPE;
91: l_rowid VARCHAR2(25);
92: l_app_req_id NUMBER;
93: l_paid_record_created BOOLEAN;
94: l_request_id NUMBER;

Line 356: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS

352: AND closed_ind = 'N'
353: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
354:
355: -- Cursor to get the meaning for lookup code
356: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
357: SELECT meaning
358: FROM igs_lookups_view
359: WHERE lookup_type = cp_lookup_type
360: AND lookup_code = cp_lookup_code;

Line 358: FROM igs_lookups_view

354:
355: -- Cursor to get the meaning for lookup code
356: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
357: SELECT meaning
358: FROM igs_lookups_view
359: WHERE lookup_type = cp_lookup_type
360: AND lookup_code = cp_lookup_code;
361:
362: l_class_meaning igs_lookups_view.meaning%TYPE;

Line 362: l_class_meaning igs_lookups_view.meaning%TYPE;

358: FROM igs_lookups_view
359: WHERE lookup_type = cp_lookup_type
360: AND lookup_code = cp_lookup_code;
361:
362: l_class_meaning igs_lookups_view.meaning%TYPE;
363: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
364: BEGIN
365: OPEN c_ad_cd_class;
366: FETCH c_ad_cd_class INTO p_code_id;

Line 363: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;

359: WHERE lookup_type = cp_lookup_type
360: AND lookup_code = cp_lookup_code;
361:
362: l_class_meaning igs_lookups_view.meaning%TYPE;
363: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
364: BEGIN
365: OPEN c_ad_cd_class;
366: FETCH c_ad_cd_class INTO p_code_id;
367: IF c_ad_cd_class%NOTFOUND THEN