APPS.OKE_BILLING_EVENT_PUB dependencies on OKE_K_LINES

Line 29: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_LINES_V';

25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
26:
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_LINES_V';
30:
31: G_EXCEPTION_HALT_VALIDATION exception;
32:
33:

Line 259: FROM oke_k_lines

255: WHERE K_Header_Id = P_Header_Id;
256:
257: CURSOR Top_C IS
258: SELECT PROJECT_ID, TASK_ID, PARENT_LINE_ID
259: FROM oke_k_lines
260: WHERE K_Line_Id = L_Line_Id;
261:
262: CURSOR Sub_C (P_Line_Id NUMBER, P_Sequence NUMBER) IS
263: SELECT PROJECT_ID, TASK_ID

Line 264: FROM OKE_K_LINES

260: WHERE K_Line_Id = L_Line_Id;
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