APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_QUOTES_V

Line 2054: FROM OKL_TRX_QUOTES_V

2050: -- Cursor to get the quote details
2051: CURSOR get_quote_details_csr ( p_quote_id IN NUMBER ) IS
2052: SELECT qtp_code,
2053: qrs_code
2054: FROM OKL_TRX_QUOTES_V
2055: WHERE id = p_quote_id;
2056:
2057: -- Cursor to get the k details
2058: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL

Line 2727: FROM okl_trx_quotes_v

2723: --- Fetch quote satus
2724:
2725: CURSOR k_quotes_csr (p_qte_id IN NUMBER) IS
2726: SELECT qst_code
2727: FROM okl_trx_quotes_v
2728: WHERE id = p_qte_id
2729: AND (qtp_code LIKE 'TER%' OR qtp_code LIKE 'RES%');
2730:
2731: BEGIN

Line 9300: FROM OKL_TRX_QUOTES_V OTQV,

9296: CURSOR c_get_repo_indicator(p_quote_id NUMBER) IS
9297: SELECT NVL(OTQV.REPO_QUOTE_INDICATOR_YN, 'N'),
9298: KHR.DEAL_TYPE,
9299: CHR.AUTHORING_ORG_ID
9300: FROM OKL_TRX_QUOTES_V OTQV,
9301: OKL_K_HEADERS KHR,
9302: OKC_K_HEADERS_B CHR
9303: WHERE OTQV.ID = p_quote_id
9304: AND OTQV.KHR_ID = KHR.ID

Line 9307: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';

9303: WHERE OTQV.ID = p_quote_id
9304: AND OTQV.KHR_ID = KHR.ID
9305: AND KHR.ID = CHR.ID;
9306:
9307: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';
9308: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
9309: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
9310:
9311: CURSOR c_get_loan_repo_params(p_org_id NUMBER) IS