APPS.AP_APPROVAL_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 608: ap_supplier_sites_all PVS

604: pvs.tolerance_id,
605: pvs.services_tolerance_id
606: FROM ap_invoices_all AI,
607: ap_suppliers PV,
608: ap_supplier_sites_all PVS
609: WHERE AI.invoice_id = p_invoice_id
610: AND AI.vendor_id = PV.vendor_id
611: AND AI.vendor_site_id = PVS.vendor_site_id;
612:

Line 7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;

7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
7145:
7146: Tax_Exception EXCEPTION;
7147:

Line 7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;

7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
7145:
7146: Tax_Exception EXCEPTION;
7147:
7148: CURSOR SELECTED_INVOICES_CURSOR IS

Line 7169: ap_supplier_sites_all S

7165: nvl(I.exclude_freight_from_discount,'N') exclude_freight_from_discount,
7166: S.tolerance_id,
7167: s.services_tolerance_id
7168: FROM ap_invoices_all I,
7169: ap_supplier_sites_all S
7170: WHERE I.vendor_site_id = S.vendor_site_id (+)
7171: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7172: ORDER BY I.org_id;
7173:

Line 7180: ap_supplier_sites_all S

7176: -- Start for bug 6511249
7177: CURSOR SELC_INV_CURSOR_BULK_ERROR IS
7178: SELECT I.invoice_id, i.invoice_num, i.org_id
7179: FROM ap_invoices_all I,
7180: ap_supplier_sites_all S
7181: WHERE I.vendor_site_id = S.vendor_site_id (+)
7182: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7183: ORDER BY I.org_id;
7184:

Line 7281: ap_supplier_sites_all s

7277: l_invoice_id, l_invoice_date, l_invoice_currency_code, l_exchange_rate,
7278: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
7279: l_services_tolerance_id
7280: FROM ap_invoices_all ai,
7281: ap_supplier_sites_all s
7282: WHERE ai.invoice_id = l_invoice_id
7283: AND ai.vendor_site_id = s.vendor_site_id(+);
7284: EXCEPTION
7285: WHEN OTHERS THEN

Line 7630: ap_supplier_sites_all s

7626: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
7627: l_services_tolerance_id
7628: FROM
7629: ap_invoices_all ai,
7630: ap_supplier_sites_all s
7631: WHERE
7632: ai.invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id
7633: AND
7634: ai.vendor_site_id = s.vendor_site_id(+);