APPS.OKE_PA_CHECKS_PUB dependencies on OKE_K_HEADERS

Line 33: SELECT project_id FROM oke_k_headers

29: l_project_id NUMBER:=Project_ID;
30:
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

Line 119: SELECT PROJECT_ID FROM oke_k_headers WHERE k_header_id = p_head_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
120: ;
121: l_line_id NUMBER := p_line_id;
122:
123: BEGIN