2352: l_debug_level4 CONSTANT NUMBER := 4;
2353: l_debug_level5 CONSTANT NUMBER := 5;
2354:
2355:
2356: --This cursor selects 'X' from dual if any non-financial task exists
2357: --in the hierarchy from PA_OBJECT_RELATIONSHIPS
2358: --for the passed task version id.
2359: CURSOR c_get_WP_rec(l_element_version_id NUMBER)
2360: IS
2358: --for the passed task version id.
2359: CURSOR c_get_WP_rec(l_element_version_id NUMBER)
2360: IS
2361: SELECT 'X'
2362: FROM dual
2363: WHERE EXISTS
2364: (
2365: SELECT proj_element_id
2366: , element_version_id