APPS.AP_VENDOR_PUB_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 996: FROM ap_system_parameters

992: x_valid := TRUE;
993:
994: SELECT allow_awt_flag
995: INTO l_asp_awt_flag
996: FROM ap_system_parameters
997: WHERE org_id = p_org_id;
998:
999: IF l_asp_awt_flag = 'N'
1000: AND p_allow_awt_flag = 'Y' THEN

Line 2207: FROM ap_system_parameters;

2203: IF p_tolerance_type = 'QUANTITY' then
2204:
2205: SELECT tolerance_id
2206: INTO l_default_tolerance
2207: FROM ap_system_parameters;
2208:
2209: ELSE
2210:
2211: SELECT services_tolerance_id

Line 2213: FROM ap_system_parameters;

2209: ELSE
2210:
2211: SELECT services_tolerance_id
2212: INTO l_default_tolerance
2213: FROM ap_system_parameters;
2214:
2215: END IF;
2216:
2217: ELSE

Line 2224: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2220: IF p_tolerance_type = 'QUANTITY' then
2221:
2222: SELECT ASP.tolerance_id
2223: INTO l_default_tolerance
2224: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2225: WHERE ASP.org_id = ORG.organization_id
2226: AND (ORG.organization_id = p_org_id OR
2227: ORG.name = p_org_name);
2228:

Line 2233: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2229: ELSE
2230:
2231: SELECT ASP.services_tolerance_id
2232: INTO l_default_tolerance
2233: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2234: WHERE ASP.org_id = ORG.organization_id
2235: AND (ORG.organization_id = p_org_id OR
2236: ORG.name = p_org_name);
2237:

Line 4460: AP_SYSTEM_PARAMETERS_ALL ASP

4456: /*
4457: SELECT FIN.vat_country_code
4458: INTO l_default_country_code
4459: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
4460: AP_SYSTEM_PARAMETERS_ALL ASP
4461: WHERE ASP.set_of_books_id=p_vendor_rec.set_of_books_id
4462: AND FIN.org_id = ASP.org_id;
4463: */
4464:

Line 7300: /* Bug 7155121 Modified the below select to get values from both ap_system_parameters_all and po_vendors*/

7296: x_calling_sequence => null);
7297:
7298: -- Retrieve defaults from the vendor master
7299:
7300: /* Bug 7155121 Modified the below select to get values from both ap_system_parameters_all and po_vendors*/
7301:
7302: SELECT nvl(pv.terms_date_basis, asp.terms_date_basis) -- Bug#7506443
7303: , pv.pay_group_lookup_code
7304: , pv.payment_priority

Line 7352: ap_system_parameters_all asp

7348: , l_party_id
7349: , l_vendor_type_lookup_code
7350: , l_sup_awt_flag
7351: FROM po_vendors pv,
7352: ap_system_parameters_all asp
7353: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
7354: AND asp.org_id=l_def_org_id;
7355:
7356: l_last_updated_by := fnd_global.user_id;

Line 8710: FROM ap_system_parameters

8706: --Bug 5305536
8707: IF p_vendor_site_rec.org_id IS NOT NULL THEN
8708: SELECT Set_Of_Books_Id
8709: INTO l_sob
8710: FROM ap_system_parameters
8711: WHERE org_id = p_vendor_site_rec.org_id;
8712: END IF;
8713:
8714: -- Call eTax Validation