APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_CR_TYPES_ALL

Line 124: igs_fi_cr_types_all crtype

120:
121: CURSOR cur_cred (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
122: SELECT crtype.credit_class
123: FROM igs_fi_credits_all crd,
124: igs_fi_cr_types_all crtype
125: WHERE crd.credit_type_id = crtype.credit_type_id
126: AND crd.credit_id = cp_n_credit_id;
127:
128: CURSOR cur_tran_type (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS

Line 135: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

131: igs_fi_applications app
132: WHERE inv.invoice_id = app.invoice_id
133: AND app.credit_id = cp_n_credit_id;
134:
135: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
136: l_v_trans_type igs_fi_inv_int_all.transaction_type%TYPE;
137: l_v_category VARCHAR2(20):= NULL;
138:
139:

Line 249: igs_fi_cr_types_all crtype

245:
246: CURSOR cur_cred (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
247: SELECT crtype.credit_class
248: FROM igs_fi_credits_all crd,
249: igs_fi_cr_types_all crtype
250: WHERE crd.credit_type_id = crtype.credit_type_id
251: AND crd.credit_id = cp_n_credit_id;
252:
253:

Line 261: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

257: WHERE inv.invoice_id = cp_n_invoice_id;
258:
259: l_v_category VARCHAR2(20) := NULL;
260: l_v_trans_type igs_fi_inv_int_all.transaction_type%TYPE;
261: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
262:
263: BEGIN
264:
265: IF (p_n_invoice_id IS NULL) OR (p_n_credit_id IS NULL) THEN