APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_TRX_QUOTES_B

Line 967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;

963: l_start_date okc_k_headers_b.start_date%type := null;
964: l_pdt_id okl_k_headers.pdt_id%type := null;
965: l_qte_id okl_k_lines.qte_id%type := null;
966: l_chk_qte_id okl_k_lines.qte_id%type := null;
967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;
968: l_khr_id okl_k_headers.khr_id%type := null;
969:
970: CURSOR l_supp_name_csr IS
971: select id1

Line 4016: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;

4012: l_not_found BOOLEAN := FALSE;
4013: l_amt NUMBER;
4014: l_found VARCHAR2(1);
4015: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
4016: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4017: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4018:
4019: l_rebook_yn VARCHAR2(1) := null;
4020: l_ln_orig_sys_id1 okc_k_lines_b.orig_system_id1%type := null;

Line 4029: FROM okc_k_headers_v khr,okl_trx_quotes_b qte

4025:
4026: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4027: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4028: SELECT khr.contract_number, qte.quote_number
4029: FROM okc_k_headers_v khr,okl_trx_quotes_b qte
4030: WHERE khr.id = chrID
4031: AND qte.id = qteID;
4032:
4033: /* Cursor to get the Fee Name. */

Line 4041: okl_trx_quotes_b qte

4037: SELECT cle.name
4038: FROM okc_k_headers_b khr,
4039: okl_k_lines kle,
4040: okc_k_lines_v cle,
4041: okl_trx_quotes_b qte
4042: WHERE cle.id = kle.id
4043: AND khr.id = chrID
4044: AND khr.id = cle.dnz_chr_id
4045: AND qte.id = qteID

Line 4055: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte

4051: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4052: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4053: SELECT 1 FROM okc_k_headers_b
4054: WHERE id = chrID
4055: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4056: WHERE khr.id = qte.khr_id
4057: AND qte.id = qteID);
4058:
4059: /* Cursor to check if the Currency Code on the current Contract

Line 4066: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte

4062: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4063: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4064: SELECT 1 FROM okc_k_headers_b
4065: WHERE id = chrID
4066: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4067: WHERE khr.id = qte.khr_id
4068: AND qte.id = qteID);
4069:
4070: /* Cursor to check if the Quote status is Approved, if not throw an error. */

Line 4073: SELECT 1 FROM okl_trx_quotes_b

4069:
4070: /* Cursor to check if the Quote status is Approved, if not throw an error. */
4071:
4072: CURSOR l_qts_code_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4073: SELECT 1 FROM okl_trx_quotes_b
4074: WHERE id = qteID
4075: AND qst_code = 'APPROVED';
4076:
4077: /* Cursor to check if the Quote Consolidate flag is set to N, if not throw an error. */

Line 4080: SELECT 1 FROM okl_trx_quotes_b

4076:
4077: /* Cursor to check if the Quote Consolidate flag is set to N, if not throw an error. */
4078:
4079: CURSOR l_con_yn_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4080: SELECT 1 FROM okl_trx_quotes_b
4081: WHERE id = qteID
4082: AND consolidated_yn = 'N';
4083:
4084: /* Cursor to check if the Quote Type is either TER_ROLL_PURCHASE or

Line 4088: SELECT 1 FROM okl_trx_quotes_b

4084: /* Cursor to check if the Quote Type is either TER_ROLL_PURCHASE or
4085: TER_ROLL_WO_PURCHASE, if not throw an error. */
4086:
4087: CURSOR l_qte_typ_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4088: SELECT 1 FROM okl_trx_quotes_b
4089: WHERE id = qteID
4090: AND qtp_code IN ('TER_ROLL_PURCHASE' , 'TER_ROLL_WO_PURCHASE');
4091:
4092: /* Cursor to check if the Rollover Fee Start date is between Quote

Line 4101: okl_trx_quotes_b qte

4097: SELECT 1
4098: FROM okc_k_headers_b khr,
4099: okl_k_lines kle,
4100: okc_k_lines_b cle,
4101: okl_trx_quotes_b qte
4102: WHERE cle.id = kle.id
4103: AND khr.id = chrID
4104: AND khr.id = cle.dnz_chr_id
4105: AND qte.id = qteID

Line 4127: FROM okl_trx_quotes_b qte, okl_txl_quote_lines_b tql

4123: -- AKJAIN fixed bug 4198968
4124: CURSOR l_rq_amt_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4125: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4126: (SELECT SUM(tql.amount)
4127: FROM okl_trx_quotes_b qte, okl_txl_quote_lines_b tql
4128: WHERE qte.id = qteID
4129: AND tql.qte_id= qte.id
4130: AND tql.qlt_code not in ('AMCFIA', 'AMCTAX', 'AMYOUB', 'BILL_ADJST'))
4131: INTERSECT