APPS.OKE_PA_CHECKS_PUB dependencies on OKE_K_LINES

Line 35: SELECT project_id FROM oke_k_lines

31: CURSOR c_used IS
32: SELECT 'Y' FROM (
33: SELECT project_id FROM oke_k_headers
34: UNION ALL
35: SELECT project_id FROM oke_k_lines
36: UNION ALL
37: SELECT project_id FROM oke_k_fund_allocations
38: UNION ALL
39: SELECT project_id FROM oke_k_deliverables_b

Line 82: SELECT task_id FROM oke_k_lines

78: l_task_id NUMBER:=Task_ID;
79:
80: CURSOR c_used IS
81: SELECT 'Y' FROM (
82: SELECT task_id FROM oke_k_lines
83: UNION ALL
84: SELECT task_id FROM oke_k_fund_allocations
85: UNION ALL
86: SELECT task_id FROM oke_k_deliverables_b

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

Line 115: FROM OKE_K_LINES

111: ORDER BY LEVEL_SEQUENCE desc
112: ;
113: CURSOR c_line(cp_line_id NUMBER) IS
114: SELECT PROJECT_ID, TASK_ID, parent_line_id
115: FROM OKE_K_LINES
116: WHERE K_LINE_ID = CP_LINE_ID AND PROJECT_ID IS NOT NULL
117: ;
118: CURSOR c_head IS
119: SELECT PROJECT_ID FROM oke_k_headers WHERE k_header_id = p_head_id

Line 255: FROM oke_k_lines e, okc_k_lines_b c

251:
252: CURSOR used_refs(p_project_ID NUMBER) IS
253: SELECT header_id, line_id, project_id FROM (
254: SELECT dnz_chr_id header_id, c.cle_id line_id, project_id
255: FROM oke_k_lines e, okc_k_lines_b c
256: WHERE e.k_line_id=c.id
257: UNION ALL
258: SELECT object_id header_id, k_line_id, project_id FROM oke_k_fund_allocations
259: UNION ALL