DBA Data[Home] [Help]

APPS.AHL_ENIGMA_UTIL_PKG dependencies on DUAL

Line 66: FROM dual;

62:
63: CURSOR get_user_and_lang IS
64: SELECT FND_GLOBAL.USER_NAME,
65: userenv('LANG')
66: FROM dual;
67:
68: CURSOR get_doc_id (c_workorder_id NUMBER)IS
69: SELECT enigma_doc_id
70: FROM ahl_workorders wo,ahl_routes_b rt

Line 304: SELECT trim(fnd_profile.value('AHL_ENIGMA_AMM_DOC_AVLBL')) INTO l_amm_doc_avail FROM dual;

300: IF l_doc_id IS NULL THEN
301: RETURN l_dont_show_task_card;
302: END IF;
303:
304: SELECT trim(fnd_profile.value('AHL_ENIGMA_AMM_DOC_AVLBL')) INTO l_amm_doc_avail FROM dual;
305: IF l_amm_doc_avail = 'Y' THEN
306: RETURN l_show_task_card;
307: ELSE
308: RETURN