APPS.OKL_CONTRACT_INFO dependencies on OKL_K_HEADERS

Line 97: FROM okl_k_headers

93: CURSOR vendor_program_csr(p_contract_id NUMBER) IS
94: SELECT SUBSTR(description,1,240) FROM okc_k_headers_tl
95: WHERE ID =
96: ( SELECT khr_id
97: FROM okl_k_headers
98: WHERE id = p_contract_id);
99:
100: l_vendor_program VARCHAR2(240);
101: l_api_version NUMBER;

Line 1150: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr

1146:
1147: -- Get contract term duration and dates
1148: CURSOR contract_dates_csr IS
1149: SELECT khr.start_date,khr.end_date,okhr.term_duration
1150: FROM OKL_K_HEADERS okhr ,okc_k_headers_v khr
1151: WHERE okhr.id = khr.id
1152: AND khr.id = p_contract_id;
1153: BEGIN
1154: OPEN contract_dates_csr;

Line 1453: FROM okl_k_headers_v khr ,fnd_lookups fnd

1449:
1450:
1451: CURSOR deal_type(p_contract_id IN NUMBER) IS
1452: SELECT khr.deal_type
1453: FROM okl_k_headers_v khr ,fnd_lookups fnd
1454: WHERE fnd.lookup_type = 'OKL_BOOK_CLASS'
1455: AND fnd.lookup_code = khr.deal_type
1456: AND id = p_contract_id;
1457: