DBA Data[Home] [Help]

APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_FI_INVLN_INT_V

Line 350: igs_fi_invln_int_v ln

346: hd.fee_ci_sequence_number,
347: hd.invoice_id,
348: hd.invoice_amount_due
349: FROM igs_fi_inv_int_all hd,
350: igs_fi_invln_int_v ln
351: WHERE hd.invoice_id = ln.invoice_id
352: AND hd.transaction_type = g_transaction_type
353: AND hd.person_id = cp_n_person_id
354: AND hd.invoice_amount_due > 0

Line 382: igs_fi_invln_int_v ln

378: hd.fee_ci_sequence_number,
379: hd.invoice_id,
380: hd.invoice_amount_due
381: FROM igs_fi_inv_int_all hd,
382: igs_fi_invln_int_v ln
383: WHERE hd.invoice_id = ln.invoice_id
384: AND hd.transaction_type = g_transaction_type
385: AND hd.person_id IN (SELECT person_id
386: FROM igs_pe_prsid_grp_mem

Line 417: igs_fi_invln_int_v ln

413: hd.fee_ci_sequence_number,
414: hd.invoice_id,
415: hd.invoice_amount_due
416: FROM igs_fi_inv_int_all hd,
417: igs_fi_invln_int_v ln
418: WHERE hd.invoice_id = ln.invoice_id
419: AND hd.transaction_type = g_transaction_type
420: AND hd.invoice_amount_due > 0
421: AND hd.fee_cal_type = cp_v_fee_cal_type