APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_VENDOR_SITES

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:

Line 1297: FROM po_vendor_sites PVS

1293: IS
1294:
1295: CURSOR primary_pay_site_cur IS
1296: SELECT vendor_site_id
1297: FROM po_vendor_sites PVS
1298: WHERE vendor_id = p_vendor_id
1299: AND pay_site_flag = 'Y'
1300: AND primary_pay_site_flag = 'Y'
1301: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)

Line 1306: FROM po_vendor_sites PVS

1302: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;
1303:
1304: CURSOR pay_site_cur IS
1305: SELECT vendor_site_id
1306: FROM po_vendor_sites PVS
1307: WHERE vendor_id = p_vendor_id
1308: AND pay_site_flag = 'Y'
1309: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1310: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;

Line 1312: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

1308: AND pay_site_flag = 'Y'
1309: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1310: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;
1311:
1312: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
1313: l_paysite_count NUMBER;
1314: current_calling_sequence VARCHAR2(2000);
1315: debug_info VARCHAR2(500);
1316:

Line 1337: FROM po_vendor_sites PVS

1333: IF ( l_vendor_site_id is null ) THEN
1334:
1335: SELECT count(*)
1336: INTO l_paysite_count
1337: FROM po_vendor_sites PVS
1338: WHERE vendor_id = p_vendor_id
1339: AND pay_site_flag = 'Y'
1340: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1341: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;