APPS.AP_PA_API_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 150: FROM po_distributions_ap_v POD, ap_invoice_distributions AID

146: AND invoice_id = X_Invoice_Id;
147:
148: SELECT count(*)
149: INTO accrue_on_receipt_num
150: FROM po_distributions_ap_v POD, ap_invoice_distributions AID
151: WHERE POD.po_distribution_id = AID.po_distribution_id
152: AND AID.invoice_id = X_invoice_id
153: AND POD.accrue_on_receipt_flag = 'Y';
154:

Line 157: FROM po_headers POH, po_distributions_ap_v POD, ap_invoice_distributions AID

153: AND POD.accrue_on_receipt_flag = 'Y';
154:
155: SELECT count(*)
156: INTO closed_po_num
157: FROM po_headers POH, po_distributions_ap_v POD, ap_invoice_distributions AID
158: WHERE POH.po_header_id = POD.po_header_id
159: AND POD.po_distribution_id = AID.po_distribution_id
160: AND AID.invoice_id = X_invoice_id
161: AND POH.closed_code = 'FINALLY CLOSED';