APPS.AP_WEB_OA_DISC_PKG dependencies on DUAL

Line 1179: FROM dual

1175: -- This query returns rows if there exist a company policy id
1176: -- of category Mileage or Per Diem for the given parameter ID
1177: SELECT 1
1178: INTO v_numRows
1179: FROM dual
1180: WHERE exists
1181: (SELECT 1
1182: FROM ap_expense_report_params expTypes
1183: WHERE expTypes.company_policy_id IS NOT NULL

Line 1226: FROM dual

1222: -- This query returns rows if there exist any schedule options
1223: -- of category Accommodations, Airfare, Car Rental, or Meals for the given parameter ID
1224: SELECT 1
1225: INTO v_numRows
1226: FROM dual
1227: WHERE EXISTS
1228: (SELECT 1
1229: FROM ap_expense_report_params expTypes
1230: WHERE expTypes.company_policy_id IS NOT NULL

Line 1272: FROM dual

1268: -- This query returns rows if there exist any required expense fields
1269: -- of category Accommodations, Airfare, Car Rental, or Meals for the given parameter ID
1270: SELECT 1
1271: INTO v_numRows
1272: FROM dual
1273: WHERE EXISTS
1274: (SELECT 1
1275: FROM ap_expense_report_params expTypes,
1276: ap_pol_cat_options catOptions

Line 1356: FROM dual

1352: BEGIN
1353: -- This query returns rows if itemizations are required for the given parameter ID
1354: SELECT 1
1355: INTO v_numRows
1356: FROM dual
1357: WHERE EXISTS
1358: (SELECT 1
1359: FROM ap_expense_report_params expTypes
1360: WHERE expTypes.itemization_required_flag = C_Yes

Line 1407: FROM dual

1403: IF (l_is_tax_enabled = C_Yes) THEN
1404: -- This query returns rows if any VAT merchant fields are required in this org
1405: SELECT 1
1406: INTO v_numRows
1407: FROM dual
1408: WHERE EXISTS
1409: (SELECT 1
1410: FROM ap_web_vat_setup
1411: WHERE

Line 1458: FROM dual

1454: BEGIN
1455: -- This query returns rows if there exist any exchange rate validation in this org
1456: SELECT 1
1457: INTO v_numRows
1458: FROM dual
1459: WHERE EXISTS
1460: (SELECT 1
1461: FROM AP_POL_EXRATE_OPTIONS WHERE ENABLED = 'Y');
1462: