APPS.OKL_CONTRACT_APPROVAL_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 24: SELECT khr_id FROM okl_k_headers_full_v

20: FUNCTION REFERENCE_EXISTS(p_contract_id IN NUMBER) RETURN VARCHAR2 IS
21: l_id NUMBER;
22: l_khr_id NUMBER;
23: CURSOR khr_id_cur IS
24: SELECT khr_id FROM okl_k_headers_full_v
25: WHERE id = p_contract_id;
26:
27: CURSOR id_cur(p_khr_id IN NUMBER) IS
28: SELECT id FROM okl_k_headers_full_v

Line 28: SELECT id FROM okl_k_headers_full_v

24: SELECT khr_id FROM okl_k_headers_full_v
25: WHERE id = p_contract_id;
26:
27: CURSOR id_cur(p_khr_id IN NUMBER) IS
28: SELECT id FROM okl_k_headers_full_v
29: WHERE khr_id = p_khr_id
30: AND sts_code = 'ACTIVE';
31:
32: l_return_status VARCHAR2(2000) := 'N';

Line 86: WHERE id = (SELECT khr_id FROM okl_k_headers_full_v

82:
83: -- Fix Bug 3159867
84:
85: CURSOR khr_num IS SELECT contract_number , authoring_org_id FROM okc_k_headers_b
86: WHERE id = (SELECT khr_id FROM okl_k_headers_full_v
87: WHERE id = p_contract_id);
88: l_khr_number okc_k_headers_b.contract_number%TYPE;
89:
90: BEGIN