DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_TOLERANCE_TEMPLATES

Line 1159: l_price_tolerance ap_tolerance_templates.price_tolerance%TYPE;

1155: p_services_total_amt_tolerance OUT NOCOPY NUMBER,
1156: p_calling_sequence IN VARCHAR2)
1157: RETURN BOOLEAN IS
1158: debug_info VARCHAR2(500);
1159: l_price_tolerance ap_tolerance_templates.price_tolerance%TYPE;
1160: BEGIN
1161:
1162: debug_info := '(Get_tolerance_info 1) Get tolerance info...';
1163: If AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' then

Line 1194: from ap_tolerance_templates att,

1190: p_max_qty_rec_tolerance,
1191: p_goods_ship_amt_tolerance,
1192: p_goods_rate_amt_tolerance,
1193: p_goods_total_amt_tolerance
1194: from ap_tolerance_templates att,
1195: po_vendor_sites_all pvs
1196: where pvs.vendor_site_id = p_vendor_site_id
1197: and pvs.tolerance_id = att.tolerance_id;
1198:

Line 1224: from ap_tolerance_templates att,

1220: p_max_amt_rec_tolerance,
1221: p_services_ship_amt_tolerance,
1222: p_services_rate_amt_tolerance,
1223: p_services_total_amt_tolerance
1224: from ap_tolerance_templates att,
1225: po_vendor_sites_all pvs
1226: where pvs.vendor_site_id = p_vendor_site_id
1227: and pvs.services_tolerance_id = att.tolerance_id;
1228: