APPS.PSA_AP_BC_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 248: po_distributions_all pod

244:
245: CURSOR c_chk_accrue_flag (p_inv_dist_id NUMBER) IS
246: SELECT NVL(pod.accrue_on_receipt_flag,'N')
247: FROM ap_invoice_distributions_all D,
248: po_distributions_all pod
249: WHERE D.invoice_distribution_id = p_inv_dist_id
250: AND D.po_distribution_id IS NOT NULL
251: AND D.po_distribution_id = pod.po_distribution_id;
252:

Line 1670: ,po_distributions_all pod

1666: CURSOR cur_get_po_encum_rev_amt IS
1667: 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
1668: FROM xla_events evt
1669: ,ap_invoice_distributions_all dist
1670: ,po_distributions_all pod
1671: WHERE evt.event_status_code = 'P'
1672: AND ( ( p_start_gl_date is not null
1673: and p_start_gl_date <= evt.transaction_date ) or
1674: ( p_start_gl_date is null ) )

Line 1703: FROM po_distributions_all

1699:
1700:
1701: CURSOR cur_dist_creation_date(l_po_dist_id NUMBER) IS
1702: SELECT creation_date
1703: FROM po_distributions_all
1704: WHERE po_distribution_id = l_po_dist_id;
1705:
1706: BEGIN
1707: l_api_name := g_full_path || '.Get_PO_Reversed_Encumb_Amount';