DBA Data[Home] [Help]

APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_CR_TYPES

Line 294: igs_fi_cr_types crt

290: CURSOR cur_chgadj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
291: SELECT SUM(appl.amount_applied) amt_appl
292: FROM igs_fi_applications appl,
293: igs_fi_credits_all crd,
294: igs_fi_cr_types crt
295: WHERE appl.invoice_id = cp_n_invoice_id
296: AND appl.credit_id = crd.credit_id
297: AND crd.credit_type_id = crt.credit_type_id
298: AND crt.credit_class = 'CHGADJ';

Line 318: igs_fi_cr_types_all crt

314: appl.application_id,
315: appl.credit_id
316: FROM igs_fi_applications appl,
317: igs_fi_credits_all crd,
318: igs_fi_cr_types_all crt
319: WHERE appl.invoice_id = cp_n_invoice_id
320: AND appl.credit_id = crd.credit_id
321: AND appl.application_type = 'APP'
322: AND crd.credit_type_id = crt.credit_type_id