APPS.IGC_CC_REP_YEP_PVT dependencies on AP_INVOICES_ALL

Line 26: l_invoice_id ap_invoices_all.invoice_id%TYPE;

22: l_canc_count NUMBER := 0;
23: l_dist_count NUMBER := 0;
24: l_appr_dist_count NUMBER := 0;
25:
26: l_invoice_id ap_invoices_all.invoice_id%TYPE;
27: l_cancelled_date ap_invoices_all.cancelled_date%TYPE;
28:
29: CURSOR c_invoices(p_cc_header_id NUMBER)
30: IS

Line 27: l_cancelled_date ap_invoices_all.cancelled_date%TYPE;

23: l_dist_count NUMBER := 0;
24: l_appr_dist_count NUMBER := 0;
25:
26: l_invoice_id ap_invoices_all.invoice_id%TYPE;
27: l_cancelled_date ap_invoices_all.cancelled_date%TYPE;
28:
29: CURSOR c_invoices(p_cc_header_id NUMBER)
30: IS
31: SELECT unique apid.invoice_id

Line 61: FROM ap_invoices_all

57: l_cancelled_date := NULL;
58:
59: SELECT cancelled_date
60: INTO l_cancelled_date
61: FROM ap_invoices_all
62: WHERE invoice_id = l_invoice_id;
63:
64: IF (l_cancelled_date IS NOT NULL)
65: THEN

Line 2298: l_invoice_id ap_invoices_all.invoice_id%TYPE;

2294: l_count NUMBER := 0;
2295: l_paid_canc_count NUMBER := 0;
2296: l_inv_dist_total NUMBER := 0;
2297:
2298: l_invoice_id ap_invoices_all.invoice_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;

Line 2299: l_cancelled_date ap_invoices_all.cancelled_date%TYPE;

2295: l_paid_canc_count NUMBER := 0;
2296: l_inv_dist_total NUMBER := 0;
2297:
2298: l_invoice_id ap_invoices_all.invoice_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;

Line 2300: l_payment_status_flag ap_invoices_all.payment_status_flag%TYPE;

2296: l_inv_dist_total NUMBER := 0;
2297:
2298: l_invoice_id ap_invoices_all.invoice_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:

Line 2326: ap_invoices_all api

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;
2330: BEGIN

Line 2352: FROM ap_invoices_all

2348: l_payment_status_flag := 'N';
2349:
2350: SELECT cancelled_date , NVL(payment_status_flag,'N')
2351: INTO l_cancelled_date, l_payment_status_flag
2352: FROM ap_invoices_all
2353: WHERE invoice_id = l_invoice_id;
2354:
2355: IF (l_cancelled_date IS NOT NULL) OR (l_payment_status_flag = 'Y')
2356: THEN