APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_INV_INT_ALL

Line 130: FROM igs_fi_inv_int_all inv,

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
129: SELECT inv.transaction_type
130: FROM igs_fi_inv_int_all inv,
131: igs_fi_applications app
132: WHERE inv.invoice_id = app.invoice_id
133: AND app.credit_id = cp_n_credit_id;
134:

Line 136: l_v_trans_type igs_fi_inv_int_all.transaction_type%TYPE;

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:
140: BEGIN

Line 254: CURSOR cur_tran_type (cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE) IS

250: WHERE crd.credit_type_id = crtype.credit_type_id
251: AND crd.credit_id = cp_n_credit_id;
252:
253:
254: CURSOR cur_tran_type (cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE) IS
255: SELECT inv.transaction_type
256: FROM igs_fi_inv_int_all inv
257: WHERE inv.invoice_id = cp_n_invoice_id;
258:

Line 256: FROM igs_fi_inv_int_all inv

252:
253:
254: CURSOR cur_tran_type (cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE) IS
255: SELECT inv.transaction_type
256: FROM igs_fi_inv_int_all inv
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;

Line 260: l_v_trans_type igs_fi_inv_int_all.transaction_type%TYPE;

256: FROM igs_fi_inv_int_all inv
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: