DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_VENDOR_SITES_ALL

Line 1135: -- Get tolerance info. from po_vendor_sites_all

1131:
1132: -- Bug 4051803
1133: --===================================================================
1134: -- Function: get_tolerance_info
1135: -- Get tolerance info. from po_vendor_sites_all
1136: -- based on vendor_site_id
1137: --===================================================================
1138: FUNCTION get_tolerance_info(
1139: p_vendor_site_id IN NUMBER,

Line 1195: po_vendor_sites_all pvs

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:
1199: EXCEPTION

Line 1225: po_vendor_sites_all pvs

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:
1229: