DBA Data[Home] [Help]

APPS.OKL_VP_ASSOCIATIONS_PVT dependencies on OKL_K_HEADERS

Line 97: FROM okl_k_headers

93: cv_get_creq_type get_creq_type_csr%ROWTYPE;
94:
95: CURSOR c_get_khr_id (cp_crs_id okl_vp_change_requests.id%TYPE)IS
96: SELECT id
97: FROM okl_k_headers
98: WHERE crs_id = cp_crs_id;
99:
100: CURSOR c_get_parent_dt_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
101: SELECT start_date

Line 337: okl_k_headers khr

333:
334: CURSOR c_get_agr_number(cp_crs_id okl_vp_change_requests.id%TYPE)IS
335: SELECT chr.contract_number
336: FROM okc_k_headers_b chr,
337: okl_k_headers khr
338: WHERE chr.id = khr.id
339: AND khr.crs_id = cp_crs_id;
340:
341: CURSOR get_agreement_name(cp_crs_id IN NUMBER) IS