APPS.IGS_FI_COM_REC_INTERFACE dependencies on IGS_FI_INV_INT

Line 174: FROM igs_fi_inv_int inv,

170: inv.invoice_number charge_number,
171: ft.s_fee_type,
172: invln.row_id invln_rowid,
173: invln.*
174: FROM igs_fi_inv_int inv,
175: igs_fi_invln_int invln,
176: igs_fi_fee_type ft
177: WHERE inv.invoice_id = invln.invoice_id
178: AND inv.fee_type = ft.fee_type

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 226: FROM igs_fi_inv_int

222: -- Returns the party_id from Charges Table correponding to the value in Source_invoice_id
223: -- column of the Credits Table of type Aid Adjustment
224: CURSOR cur_credit_stdnt_party(cp_source_invoice_id igs_fi_credits_all.source_invoice_id%TYPE) IS
225: SELECT person_id
226: FROM igs_fi_inv_int
227: WHERE invoice_id = cp_source_invoice_id
228: AND transaction_type = g_v_aid_adj;
229:
230: l_v_title igs_ps_ver.title%TYPE := NULL;

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;