APPS.OKE_PA_CHECKS_PUB dependencies on DUAL

Line 159: SELECT 'x' FROM dual

155: FUNCTION is_Hierarchy_Valid( p_from_proj NUMBER, p_from_task NUMBER, p_to_proj NUMBER,
156: p_delf_proj NUMBER, p_delf_task NUMBER, p_delt_proj NUMBER)
157: RETURN BOOLEAN IS
158: CURSOR check_prj_hier IS
159: SELECT 'x' FROM dual
160: WHERE p_to_proj IN (
161: SELECT object_id_to1 prj_id FROM (
162: SELECT *
163: FROM pa_object_relationships

Line 283: SELECT p_project_ID FROM DUAL

279: AND ppevs.latest_eff_published_flag = 'Y')
280: CONNECT BY object_id_from1 = PRIOR object_id_to1
281: AND relationship_type IN('S','LF')
282: UNION ALL
283: SELECT p_project_ID FROM DUAL
284: ) ORDER BY project_id, line_id
285: ;
286:
287: lp_proj NUMBER;