DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_TAX_CODES

Line 1144: FROM AP_TAX_CODES

1140: -- error.
1141: -- If web_enabled_flag is null should assume P_Default_No_Flag.
1142: SELECT NVL(WEB_ENABLED_FLAG, 'N')
1143: INTO p_tax_web_enabled
1144: FROM AP_TAX_CODES
1145: WHERE NAME = P_ExpTypeDefaultTaxCode
1146: AND nvl(enabled_flag, 'Y') = 'Y'
1147: AND nvl(web_enabled_flag,'N') = 'Y';
1148:

Line 1255: FROM AP_TAX_CODES

1251:
1252: -- Return Vat Code according to Tax Code ID
1253: SELECT NAME
1254: INTO P_VatCode
1255: FROM AP_TAX_CODES
1256: WHERE TAX_ID = P_TaxCodeID;
1257:
1258: RETURN TRUE;
1259:

Line 1284: FROM AP_TAX_CODES

1280:
1281: -- Return Tax Code Id using Vat Code
1282: SELECT TAX_ID
1283: INTO P_TAXCodeID
1284: FROM AP_TAX_CODES
1285: WHERE NAME = P_VatCode;
1286:
1287: RETURN TRUE;
1288:

Line 1314: FROM AP_TAX_CODES

1310:
1311: -- Return Tax Code Id using Vat Code
1312: SELECT TAX_ID
1313: INTO P_TAXCodeID
1314: FROM AP_TAX_CODES
1315: WHERE NAME = P_VatCode
1316: AND nvl(enabled_flag, 'Y') = 'Y'
1317: AND nvl(P_ExpLine_Date,sysdate) BETWEEN
1318: nvl(start_date,nvl(P_ExpLine_Date,sysdate)) AND