APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKE_K_LINES_V

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

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

Line 231: from oke_k_lines_v

227: IS
228:
229: CURSOR c_dates IS
230: select max(start_date), min(end_date)
231: from oke_k_lines_v
232: where k_line_id in (select cle_id_ascendant from okc_ancestrys
233: where cle_id = p_line_id) ;
234:
235:

Line 346: from oke_k_lines_v

342: l_exit NUMBER := 0;
343:
344: cursor parent_cursor(l_id NUMBER) is
345: select start_date, end_date
346: from oke_k_lines_v
347: where k_line_id = l_id;
348:
349: cursor child_cursor(l_id NUMBER) is
350: select start_date, end_date

Line 351: from oke_k_lines_v

347: where k_line_id = l_id;
348:
349: cursor child_cursor(l_id NUMBER) is
350: select start_date, end_date
351: from oke_k_lines_v
352: where k_line_id in
353: (
354: select cle_id from okc_ancestrys
355: where cle_id_ascendant=l_id

Line 3236: select 'x' from oke_k_lines_v

3232:
3233: l_header_id NUMBER;
3234:
3235: CURSOR c_check (p_header_id NUMBER, p_code VARCHAR2) IS
3236: select 'x' from oke_k_lines_v
3237: where billing_method_code = p_code
3238: and header_id = p_header_id;
3239:
3240: l_check VARCHAR2(1) := '?';