APPS.IGS_FI_COM_REC_INTERFACE dependencies on IGS_PS_VER

Line 210: CURSOR cur_course_desc(cp_course_cd igs_ps_ver.course_cd%TYPE) IS

206: AND crt.credit_class IN (g_v_chgadj, g_v_spnsp)
207: AND cra.gl_posted_date IS NULL
208: FOR UPDATE OF cra.gl_posted_date NOWAIT;
209:
210: CURSOR cur_course_desc(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
211: SELECT title
212: FROM igs_ps_ver
213: WHERE course_cd = cp_course_cd;
214:

Line 212: FROM igs_ps_ver

208: FOR UPDATE OF cra.gl_posted_date NOWAIT;
209:
210: CURSOR cur_course_desc(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
211: SELECT title
212: FROM igs_ps_ver
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.

Line 230: l_v_title igs_ps_ver.title%TYPE := NULL;

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;
231:
232: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
233: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
234: