DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_TOLERANCE_TEMPLATES

Line 1840: l_price_tolerance ap_tolerance_templates.price_tolerance%TYPE;

1836: p_services_total_amt_tolerance OUT NOCOPY NUMBER,
1837: p_calling_sequence IN VARCHAR2)
1838: RETURN BOOLEAN IS
1839: debug_info VARCHAR2(500);
1840: l_price_tolerance ap_tolerance_templates.price_tolerance%TYPE;
1841: BEGIN
1842:
1843: debug_info := '(Get_tolerance_info 1) Get tolerance info...';
1844: If AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' then

Line 1876: from ap_tolerance_templates att,

1872: p_max_qty_rec_tolerance,
1873: p_goods_ship_amt_tolerance,
1874: p_goods_rate_amt_tolerance,
1875: p_goods_total_amt_tolerance
1876: from ap_tolerance_templates att,
1877: po_vendor_sites_all pvs
1878: where pvs.vendor_site_id = p_vendor_site_id
1879: and pvs.tolerance_id = att.tolerance_id;
1880:

Line 1906: from ap_tolerance_templates att,

1902: p_max_amt_rec_tolerance,
1903: p_services_ship_amt_tolerance,
1904: p_services_rate_amt_tolerance,
1905: p_services_total_amt_tolerance
1906: from ap_tolerance_templates att,
1907: po_vendor_sites_all pvs
1908: where pvs.vendor_site_id = p_vendor_site_id
1909: and pvs.services_tolerance_id = att.tolerance_id;
1910: