APPS.OKL_CONTRACT_APPROVAL_PVT dependencies on OKC_K_HEADERS_B

Line 85: CURSOR khr_num IS SELECT contract_number , authoring_org_id FROM okc_k_headers_b

81: l_authoring_org_id NUMBER; --CDUBEY l_authoring_org_id added for MOAC
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:

Line 88: l_khr_number okc_k_headers_b.contract_number%TYPE;

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
91: -- CHECK_FOR_NULL_CONTRACT_ID;
92: -- If status type is not 'PASSED', do not proceed