APPS.IGS_FI_COM_REC_INTERFACE dependencies on IGS_FI_INV_INT_ALL

Line 217: CURSOR cur_chg_stdnt_party(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

213: WHERE course_cd = cp_course_cd;
214:
215: -- Returns the party_id from Credits table corresponding to the charge denoted by
216: -- the SOURCE_INVOICE_ID column.
217: CURSOR cur_chg_stdnt_party(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
218: SELECT party_id
219: FROM igs_fi_credits
220: WHERE source_invoice_id = cp_invoice_id;
221:

Line 252: l_n_credit_stdnt_party igs_fi_inv_int_all.person_id%TYPE;

248:
249: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
250:
251: l_n_chg_stdnt_party igs_fi_credits_all.party_id%TYPE;
252: l_n_credit_stdnt_party igs_fi_inv_int_all.person_id%TYPE;
253:
254: BEGIN
255: BEGIN
256: l_org_id := NULL;