DBA Data[Home] [Help]

APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_FI_CR_TYPES_ALL

Line 52: g_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;

48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';
50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';
51: g_null CONSTANT VARCHAR2(1):= NULL;
52: g_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
53:
54: do_nothing EXCEPTION;
55:
56: -- Pl/SQL table for storing all Student Program Attempts

Line 325: CURSOR cur_cr_type_names(cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE) IS

321: SELECT person_number, full_name
322: FROM igs_fi_parties_v
323: WHERE person_id = cp_n_person_id;
324:
325: CURSOR cur_cr_type_names(cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE) IS
326: SELECT credit_type_name,payment_credit_type_name
327: FROM igs_fi_cr_types_v
328: WHERE credit_type_id = cp_credit_type_id;
329: