APPS.GMS_PA_COSTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 532: FROM ap_invoice_distributions_all apdist

528:
529: -- Cursor to fetch amount on invoice distribution
530: CURSOR c_ap_amt IS
531: SELECT NVL(apdist.base_amount,apdist.amount)
532: FROM ap_invoice_distributions_all apdist
533: WHERE apdist.invoice_distribution_id = g_xface_rec.invoice_distribution_id
534: AND apdist.invoice_id = g_xface_rec.invoice_id ;
535:
536: -- Bug : 5414183

Line 586: ap_invoice_distributions_all apd

582: -- ====================================================================================
583: CURSOR c_get_disc_amount is
584: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
585: from ap_payment_hist_dists b,
586: ap_invoice_distributions_all apd
587: where b.invoice_payment_id = g_xface_rec.cdl_system_reference4
588: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
589: and b.pay_dist_lookup_code = 'DISCOUNT'
590: and apd.invoice_distribution_id = b.invoice_distribution_id

Line 3348: ap_invoice_distributions_all apd,

3344: v_login
3345: from pa_transaction_interface_all txn,
3346: pa_expenditure_items_all ei,
3347: pa_cost_distribution_lines_all cdl,
3348: ap_invoice_distributions_all apd,
3349: gms_award_distributions adl
3350: where txn.interface_id = p_xface_id
3351: and nvl(txn.transaction_status_code, 'Z') <> 'R'
3352: and txn.batch_name = p_batch