APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_INV_INT

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:

Line 653: igs_fi_inv_int inv

649: inv.invoice_number,
650: inv.transaction_type,
651: inv.person_id
652: FROM igs_fi_invln_int ln,
653: igs_fi_inv_int inv
654: WHERE ln.invoice_id = inv.invoice_id
655: AND ln.gl_date IS NOT NULL
656: AND TRUNC(ln.gl_date) >= TRUNC(cp_gl_date_start)
657: AND TRUNC(ln.gl_date) <= TRUNC(cp_gl_date_end)

Line 785: igs_fi_inv_int inv

781: crd.credit_number,
782: inv.person_id
783: FROM igs_fi_applications app,
784: igs_fi_credits crd,
785: igs_fi_inv_int inv
786: WHERE crd.credit_id = app.credit_id
787: AND inv.invoice_id = app.invoice_id
788: AND app.gl_date IS NOT NULL
789: AND TRUNC(app.gl_date) >= TRUNC(cp_gl_date_start)