APPS.IGC_CC_REP_YEP_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 34: po_distributions_all pod,

30: IS
31: SELECT unique apid.invoice_id
32: FROM
33: ap_invoice_distributions_all apid,
34: po_distributions_all pod,
35: po_headers_all phh,
36: igc_cc_headers cch
37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND

Line 2303: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

2299: l_cancelled_date ap_invoices_all.cancelled_date%TYPE;
2300: l_payment_status_flag ap_invoices_all.payment_status_flag%TYPE;
2301:
2302: l_po_header_id po_headers_all.po_header_id%TYPE;
2303: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
2304:
2305: l_invoice_canc_paid_flag BOOLEAN := FALSE;
2306:
2307: CURSOR c_po_distributions(p_cc_header_id NUMBER)

Line 2311: po_distributions_all pod,

2307: CURSOR c_po_distributions(p_cc_header_id NUMBER)
2308: IS
2309: SELECT pod.po_distribution_id
2310: FROM
2311: po_distributions_all pod,
2312: po_headers_all phh,
2313: igc_cc_headers cch
2314: WHERE
2315: pod.po_header_id = phh.po_header_id AND