DBA Data[Home] [Help]

APPS.OKE_PA_CHECKS_PUB dependencies on OKC_ANCESTRYS

Line 109: FROM OKE_K_LINES E, OKC_ANCESTRYS A

105: ) IS
106:
107: CURSOR c_plines IS
108: SELECT PROJECT_ID, TASK_ID
109: FROM OKE_K_LINES E, OKC_ANCESTRYS A
110: WHERE K_LINE_ID = CLE_ID_ASCENDANT AND CLE_ID = P_LINE_ID AND PROJECT_ID IS NOT NULL
111: ORDER BY LEVEL_SEQUENCE desc
112: ;
113: CURSOR c_line(cp_line_id NUMBER) IS