APPS.OKE_BILLING_EVENT_PUB dependencies on OKC_ANCESTRYS

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

261:
262: CURSOR Sub_C (P_Line_Id NUMBER, P_Sequence NUMBER) IS
263: SELECT PROJECT_ID, TASK_ID
264: FROM OKE_K_LINES
265: WHERE K_LINE_ID = (SELECT CLE_ID_ASCENDANT FROM OKC_ANCESTRYS WHERE CLE_ID = P_LINE_ID AND LEVEL_SEQUENCE = P_SEQUENCE)
266: AND PROJECT_ID IS NOT NULL;
267:
268: CURSOR C (P_ID NUMBER, P_ID1 NUMBER, P_ID2 NUMBER) IS
269: SELECT 'X'

Line 285: FROM OKC_ANCESTRYS

281: WHERE Project_ID = P_ID1);
282:
283: CURSOR Seq_C (P_ID NUMBER ) IS
284: SELECT MAX(LEVEL_SEQUENCE)
285: FROM OKC_ANCESTRYS
286: WHERE CLE_ID = P_ID;
287:
288: Begin
289: