APPS.AP_VENDOR_PUB_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 1164: FROM ap_system_parameters

1160: x_valid := TRUE;
1161:
1162: SELECT allow_awt_flag
1163: INTO l_asp_awt_flag
1164: FROM ap_system_parameters
1165: WHERE org_id = p_org_id;
1166:
1167: IF l_asp_awt_flag = 'N'
1168: AND p_allow_awt_flag = 'Y' THEN

Line 2518: FROM ap_system_parameters;

2514: IF p_tolerance_type = 'QUANTITY' then
2515:
2516: SELECT tolerance_id
2517: INTO l_default_tolerance
2518: FROM ap_system_parameters;
2519:
2520: ELSE
2521:
2522: SELECT services_tolerance_id

Line 2524: FROM ap_system_parameters;

2520: ELSE
2521:
2522: SELECT services_tolerance_id
2523: INTO l_default_tolerance
2524: FROM ap_system_parameters;
2525:
2526: END IF;
2527:
2528: ELSE

Line 2535: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2531: IF p_tolerance_type = 'QUANTITY' then
2532:
2533: SELECT ASP.tolerance_id
2534: INTO l_default_tolerance
2535: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2536: WHERE ASP.org_id = ORG.organization_id
2537: AND (ORG.organization_id = p_org_id OR
2538: ORG.name = p_org_name);
2539:

Line 2544: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2540: ELSE
2541:
2542: SELECT ASP.services_tolerance_id
2543: INTO l_default_tolerance
2544: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2545: WHERE ASP.org_id = ORG.organization_id
2546: AND (ORG.organization_id = p_org_id OR
2547: ORG.name = p_org_name);
2548:

Line 5121: AP_SYSTEM_PARAMETERS_ALL ASP

5117: /*
5118: SELECT FIN.vat_country_code
5119: INTO l_default_country_code
5120: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
5121: AP_SYSTEM_PARAMETERS_ALL ASP
5122: WHERE ASP.set_of_books_id=p_vendor_rec.set_of_books_id
5123: AND FIN.org_id = ASP.org_id;
5124: */
5125:

Line 7927: l_create_awt_dists_type ap_system_parameters_all.create_awt_dists_type%type; --bug 13092500

7923: VAT_CODE_EXCEPTION EXCEPTION;
7924: /* Bug11664523 end */
7925:
7926: l_employee_id ap_suppliers.employee_id%type; --bug 12835899
7927: l_create_awt_dists_type ap_system_parameters_all.create_awt_dists_type%type; --bug 13092500
7928:
7929: /* Bug 12334398 start */
7930: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
7931: l_site_use_return_status VARCHAR2(50) := 'S';

Line 8254: ap_system_parameters_all asp,

8250: , l_vendor_type_lookup_code
8251: , l_sup_awt_flag
8252: ,l_create_debit_memo_flag --Bug8373166
8253: FROM po_vendors pv,
8254: ap_system_parameters_all asp,
8255: ap_product_setup aps -- Bug 8200984
8256: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8257: AND asp.org_id=l_def_org_id;
8258:

Line 8277: ap_system_parameters_all asp

8273: l_sup_terms_date_basis,
8274: l_sup_pay_date_basis_lk_code,
8275: l_sup_terms_id
8276: FROM po_vendors pv,
8277: ap_system_parameters_all asp
8278: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8279: AND asp.org_id=l_def_org_id;
8280:
8281: /* Partial End of bug8892266 */

Line 10014: FROM ap_system_parameters

10010: --Bug 5305536
10011: IF p_vendor_site_rec.org_id IS NOT NULL THEN
10012: SELECT Set_Of_Books_Id
10013: INTO l_sob
10014: FROM ap_system_parameters
10015: WHERE org_id = p_vendor_site_rec.org_id;
10016: END IF;
10017:
10018: /* Bug 9804982 Start */