APPS.GMS_PA_COSTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 542: FROM ap_invoice_distributions_all apdist

538:
539: -- Cursor to fetch amount on invoice distribution
540: CURSOR c_ap_amt IS
541: SELECT NVL(apdist.base_amount,apdist.amount)
542: FROM ap_invoice_distributions_all apdist
543: WHERE apdist.invoice_distribution_id = g_xface_rec.invoice_distribution_id
544: AND apdist.invoice_id = g_xface_rec.invoice_id
545: union /* BUG 14216205 : Added the union for SAT */
546: select NVL(APSAT.BASE_AMOUNT,APSAT.AMOUNT)

Line 601: ap_invoice_distributions_all apd

597: -- ====================================================================================
598: CURSOR c_get_disc_amount is
599: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
600: from ap_payment_hist_dists b,
601: ap_invoice_distributions_all apd
602: where b.invoice_payment_id = g_xface_rec.cdl_system_reference4
603: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
604: and b.pay_dist_lookup_code = 'DISCOUNT'
605: and apd.invoice_distribution_id = b.invoice_distribution_id

Line 3431: ap_invoice_distributions_all apd,

3427: v_login
3428: from pa_transaction_interface_all txn,
3429: pa_expenditure_items_all ei,
3430: pa_cost_distribution_lines_all cdl,
3431: ap_invoice_distributions_all apd,
3432: gms_award_distributions adl
3433: where txn.interface_id = p_xface_id
3434: and nvl(txn.transaction_status_code, 'Z') <> 'R'
3435: and txn.batch_name = p_batch