APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_CREDITS

Line 121: CURSOR cur_cred (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS

117: shtatiko 18-NOV-03 Bug# 3256915, Added INSTALLMENT_PAYMENTS when checking the credit class.
118: agairola 16-Dec-02 Bug: 2584741 added the code for Deposits functionality
119: ******************************************************************/
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

Line 123: FROM igs_fi_credits_all crd,

119: ******************************************************************/
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:

Line 128: CURSOR cur_tran_type (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS

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
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

Line 246: CURSOR cur_cred (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS

242: shtatiko 18-NOV-03 Bug# 3256915, Added INSTALLMENT_PAYMENTS when checking the credit class.
243: ******************************************************************/
244:
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

Line 248: FROM igs_fi_credits_all crd,

244:
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:

Line 534: igs_fi_credits crd

530: SELECT cra.rowid,cra.*,
531: crd.credit_number credit_number,
532: crd.party_id party_id
533: FROM igs_fi_cr_activities cra,
534: igs_fi_credits crd
535: WHERE cra.gl_date IS NOT NULL
536: AND ((cra.POSTING_ID IS NULL) AND (cra.POSTING_CONTROL_ID IS NULL))
537: AND TRUNC(cra.gl_date) >= TRUNC(cp_gl_date_start)
538: AND TRUNC(cra.gl_date) <= TRUNC(cp_gl_date_end)

Line 784: igs_fi_credits crd,

780: inv.invoice_number,
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