APPS.OKL_AM_RESTRUCTURE_QUOTE_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 30: FROM OKL_K_HEADERS_FULL_V K

26:
27: -- Cursor to get the contract end_date
28: CURSOR l_khr_csr (p_khr_id IN NUMBER) IS
29: SELECT K.end_date
30: FROM OKL_K_HEADERS_FULL_V K
31: WHERE K.id = p_khr_id;
32:
33: BEGIN
34: -- Get the sysdate

Line 354: OKL_K_HEADERS_FULL_V K

350: CURSOR k_details_for_qte_csr (p_qte_id IN NUMBER) IS
351: SELECT K.id,
352: K.contract_number
353: FROM OKL_TRX_QUOTES_V Q,
354: OKL_K_HEADERS_FULL_V K
355: WHERE Q.id = p_qte_id
356: AND Q.khr_id = K.id;
357:
358: -- Get the accepted_yn flag

Line 694: OKL_K_HEADERS_FULL_V OKHV

690: OTQV.quote_number,
691: OTQV.id qte_id,
692: OTQV.qtp_code
693: FROM OKL_TRX_QUOTES_V OTQV,
694: OKL_K_HEADERS_FULL_V OKHV
695: WHERE OTQV.id = p_id
696: AND OTQV.khr_id = OKHV.id;
697:
698:

Line 702: FROM OKL_K_HEADERS_FULL_V K

698:
699: -- Cursor to get the contract number
700: CURSOR get_k_num_csr ( p_khr_id IN NUMBER) IS
701: SELECT contract_number
702: FROM OKL_K_HEADERS_FULL_V K
703: WHERE K.id = p_khr_id;
704:
705: lp_quot_rec quot_rec_type := p_quot_rec;
706: l_q_eff_quot_rec quot_rec_type;