APPS.PSA_AP_BC_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 683: po_distributions_all pod

679: p_inv_dist_id NUMBER
680: ) IS
681: SELECT NVL(pod.accrue_on_receipt_flag,'N')
682: FROM ap_invoice_distributions_all d,
683: po_distributions_all pod
684: WHERE d.invoice_distribution_id = p_inv_dist_id
685: AND d.po_distribution_id IS NOT NULL
686: AND d.po_distribution_id = pod.po_distribution_id;
687:

Line 2170: po_distributions_all pod

2166: CURSOR cur_get_po_encum_rev_amt IS
2167: SELECT NVL(sum((NVL(dist.amount,0) - NVL(dist.amount_variance,0) - NVL(dist.quantity_variance,0))*nvl(pod.rate,1)), 0) po_reversed_encumbered_amount
2168: FROM xla_events evt,
2169: ap_invoice_distributions_all dist,
2170: po_distributions_all pod
2171: WHERE evt.event_status_code = 'P'
2172: AND ((p_start_gl_date is not null
2173: AND p_start_gl_date <= evt.transaction_date )
2174: OR(p_start_gl_date is null ))

Line 2204: FROM po_distributions_all

2200: (
2201: l_po_dist_id NUMBER
2202: ) IS
2203: SELECT creation_date
2204: FROM po_distributions_all
2205: WHERE po_distribution_id = l_po_dist_id;
2206:
2207: BEGIN
2208: l_api_name := g_full_path || '.Get_PO_Reversed_Encumb_Amount';