DBA Data[Home] [Help]

APPS.IGS_FI_CREDIT_PVT dependencies on IGS_FI_INVLN_INT_ALL

Line 89: CURSOR cur_override_dr(cp_invoice_id igs_fi_invln_int_all.invoice_id%TYPE) IS

85:
86: --Cursors used in this procedure
87:
88: --Cursor to derive revenue account from the credit account of source charge transaction.
89: CURSOR cur_override_dr(cp_invoice_id igs_fi_invln_int_all.invoice_id%TYPE) IS
90: SELECT rev_account_cd, rev_gl_ccid
91: FROM igs_fi_invln_int_all
92: WHERE invoice_id = cp_invoice_id;
93:

Line 91: FROM igs_fi_invln_int_all

87:
88: --Cursor to derive revenue account from the credit account of source charge transaction.
89: CURSOR cur_override_dr(cp_invoice_id igs_fi_invln_int_all.invoice_id%TYPE) IS
90: SELECT rev_account_cd, rev_gl_ccid
91: FROM igs_fi_invln_int_all
92: WHERE invoice_id = cp_invoice_id;
93:
94: --Cursor to fetch the admission application number for an application id and person id.
95: CURSOR cur_adm_app_num ( cp_application_id igs_ad_appl.application_id%TYPE,