APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_QUOTES_V

Line 1938: FROM OKL_TRX_QUOTES_V

1934: -- Cursor to get the quote details
1935: CURSOR get_quote_details_csr ( p_quote_id IN NUMBER ) IS
1936: SELECT qtp_code,
1937: qrs_code
1938: FROM OKL_TRX_QUOTES_V
1939: WHERE id = p_quote_id;
1940:
1941: -- Cursor to get the k details
1942: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL

Line 2611: FROM okl_trx_quotes_v

2607: --- Fetch quote satus
2608:
2609: CURSOR k_quotes_csr (p_qte_id IN NUMBER) IS
2610: SELECT qst_code
2611: FROM okl_trx_quotes_v
2612: WHERE id = p_qte_id
2613: AND (qtp_code LIKE 'TER%' OR qtp_code LIKE 'RES%');
2614:
2615: BEGIN

Line 9101: FROM OKL_TRX_QUOTES_V OTQV,

9097: CURSOR c_get_repo_indicator(p_quote_id NUMBER) IS
9098: SELECT NVL(OTQV.REPO_QUOTE_INDICATOR_YN, 'N'),
9099: KHR.DEAL_TYPE,
9100: CHR.AUTHORING_ORG_ID
9101: FROM OKL_TRX_QUOTES_V OTQV,
9102: OKL_K_HEADERS KHR,
9103: OKC_K_HEADERS_B CHR
9104: WHERE OTQV.ID = p_quote_id
9105: AND OTQV.KHR_ID = KHR.ID

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

9104: WHERE OTQV.ID = p_quote_id
9105: AND OTQV.KHR_ID = KHR.ID
9106: AND KHR.ID = CHR.ID;
9107:
9108: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';
9109: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
9110: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
9111:
9112: CURSOR c_get_loan_repo_params(p_org_id NUMBER) IS