APPS.OKE_DELIVERABLE_PVT dependencies on OKC_ANCESTRYS

Line 98: AND NOT EXISTS(SELECT 'X' FROM okc_ancestrys

94: CURSOR C (P_ID NUMBER) IS
95: SELECT 'X'
96: FROM okc_k_lines_b
97: WHERE ID = P_ID
98: AND NOT EXISTS(SELECT 'X' FROM okc_ancestrys
99: WHERE Cle_ID_Ascendant = P_ID);
100:
101: Begin
102:

Line 246: WHERE K_LINE_ID = (SELECT CLE_ID_ASCENDANT FROM OKC_ANCESTRYS WHERE CLE_ID = P_LINE_ID AND LEVEL_SEQUENCE = P_SEQUENCE)

242:
243: CURSOR Sub_C (P_Line_Id NUMBER, P_Sequence NUMBER) IS
244: SELECT PROJECT_ID, TASK_ID
245: FROM OKE_K_LINES
246: WHERE K_LINE_ID = (SELECT CLE_ID_ASCENDANT FROM OKC_ANCESTRYS WHERE CLE_ID = P_LINE_ID AND LEVEL_SEQUENCE = P_SEQUENCE)
247: AND PROJECT_ID IS NOT NULL;
248:
249: CURSOR C (P_ID NUMBER, P_ID1 NUMBER, P_ID2 NUMBER) IS
250: SELECT 'X'

Line 266: FROM OKC_ANCESTRYS

262: WHERE Project_ID = P_ID1);
263:
264: CURSOR Seq_C (P_ID NUMBER ) IS
265: SELECT MAX(LEVEL_SEQUENCE)
266: FROM OKC_ANCESTRYS
267: WHERE CLE_ID = P_ID;
268:
269: Begin
270: