DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_TAX_CODES

Line 1102: FROM AP_TAX_CODES

1098: -- error.
1099: -- If web_enabled_flag is null should assume P_Default_No_Flag.
1100: SELECT NVL(WEB_ENABLED_FLAG, 'N')
1101: INTO p_tax_web_enabled
1102: FROM AP_TAX_CODES
1103: WHERE NAME = P_ExpTypeDefaultTaxCode
1104: AND nvl(enabled_flag, 'Y') = 'Y'
1105: AND nvl(web_enabled_flag,'N') = 'Y';
1106:

Line 1213: FROM AP_TAX_CODES

1209:
1210: -- Return Vat Code according to Tax Code ID
1211: SELECT NAME
1212: INTO P_VatCode
1213: FROM AP_TAX_CODES
1214: WHERE TAX_ID = P_TaxCodeID;
1215:
1216: RETURN TRUE;
1217:

Line 1242: FROM AP_TAX_CODES

1238:
1239: -- Return Tax Code Id using Vat Code
1240: SELECT TAX_ID
1241: INTO P_TAXCodeID
1242: FROM AP_TAX_CODES
1243: WHERE NAME = P_VatCode;
1244:
1245: RETURN TRUE;
1246:

Line 1272: FROM AP_TAX_CODES

1268:
1269: -- Return Tax Code Id using Vat Code
1270: SELECT TAX_ID
1271: INTO P_TAXCodeID
1272: FROM AP_TAX_CODES
1273: WHERE NAME = P_VatCode
1274: AND nvl(enabled_flag, 'Y') = 'Y'
1275: AND nvl(P_ExpLine_Date,sysdate) BETWEEN
1276: nvl(start_date,nvl(P_ExpLine_Date,sysdate)) AND