DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_UTILS dependencies on DUAL

Line 2305: --This cursor selects 'X' from dual if any non-financial task exists

2301: l_debug_level4 CONSTANT NUMBER := 4;
2302: l_debug_level5 CONSTANT NUMBER := 5;
2303:
2304:
2305: --This cursor selects 'X' from dual if any non-financial task exists
2306: --in the hierarchy from PA_OBJECT_RELATIONSHIPS
2307: --for the passed task version id.
2308: CURSOR c_get_WP_rec(l_element_version_id NUMBER)
2309: IS

Line 2311: FROM dual

2307: --for the passed task version id.
2308: CURSOR c_get_WP_rec(l_element_version_id NUMBER)
2309: IS
2310: SELECT 'X'
2311: FROM dual
2312: WHERE EXISTS
2313: (
2314: SELECT proj_element_id
2315: , element_version_id