APPS.IGC_CC_REP_YEP_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 33: ap_invoice_distributions_all apid,

29: CURSOR c_invoices(p_cc_header_id NUMBER)
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

Line 76: ap_invoice_distributions_all

72: BEGIN
73: SELECT count(invoice_distribution_id)
74: INTO l_dist_count
75: FROM
76: ap_invoice_distributions_all
77: WHERE invoice_id = l_invoice_id;
78: EXCEPTION
79: WHEN NO_DATA_FOUND
80: THEN

Line 91: ap_invoice_distributions_all

87: BEGIN
88: SELECT count(invoice_distribution_id)
89: INTO l_appr_dist_count
90: FROM
91: ap_invoice_distributions_all
92: WHERE invoice_id = l_invoice_id AND
93: NVL(match_status_flag,'X') = 'A' AND
94: NVL(exchange_rate_variance,0) = 0;
95: EXCEPTION

Line 108: ap_invoice_distributions_all

104: BEGIN
105: SELECT count(invoice_distribution_id)
106: INTO l_appr_dist_count
107: FROM
108: ap_invoice_distributions_all
109: WHERE invoice_id = l_invoice_id AND
110: NVL(match_status_flag, 'X') = 'A' ;
111: EXCEPTION
112: WHEN NO_DATA_FOUND

Line 2325: ap_invoice_distributions_all apid,

2321: CURSOR c_invoices(p_po_distribution_id NUMBER)
2322: IS
2323: SELECT unique api.invoice_id
2324: FROM
2325: ap_invoice_distributions_all apid,
2326: ap_invoices_all api
2327: WHERE
2328: apid.invoice_id = api.invoice_id AND
2329: apid.po_distribution_id = p_po_distribution_id;

Line 2365: ap_invoice_distributions_all apid

2361:
2362: SELECT SUM(NVL(apid.amount,0))
2363: INTO l_inv_dist_total
2364: FROM
2365: ap_invoice_distributions_all apid
2366: WHERE
2367: apid.invoice_id = l_invoice_id AND
2368: apid.po_distribution_id = l_po_distribution_id ;
2369: