DBA Data[Home] [Help]

APPS.OKE_CLE_PVT dependencies on OKC_ANCESTRYS

Line 245: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE

241: WHERE ID = p_cle_rec.K_LINE_ID;
242:
243: CURSOR get_higher IS
244: SELECT KE.PROJECT_ID,KE.TASK_ID
245: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE
246: WHERE AN.CLE_ID=L_PARENT_LINE_ID AND KE.PROJECT_ID IS NOT NULL
247: AND AN.CLE_ID_ASCENDANT = KE.K_LINE_ID
248: ORDER BY AN.LEVEL_SEQUENCE DESC;
249:

Line 443: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE

439: WHERE ID = p_cle_rec.K_LINE_ID;
440:
441: CURSOR get_higher IS
442: SELECT KE.PROJECT_ID,KE.TASK_ID
443: FROM OKC_ANCESTRYS AN, OKE_K_LINES KE
444: WHERE AN.CLE_ID=L_PARENT_LINE_ID AND KE.PROJECT_ID IS NOT NULL
445: AND AN.CLE_ID_ASCENDANT = KE.K_LINE_ID
446: ORDER BY AN.LEVEL_SEQUENCE DESC;
447: