APPS.OKL_AM_INVOICES_PVT dependencies on OKL_TRX_QUOTES_B

Line 679: FROM okl_trx_quotes_b

675: -- Following cursor retrieves the quote type for the given quote id
676: CURSOR quote_type_csr (p_quote_id IN NUMBER)
677: IS
678: SELECT qtp_code
679: FROM okl_trx_quotes_b
680: WHERE id = p_quote_id;
681:
682: bill_quote_type VARCHAR2(200);
683: bill_cpl_id NUMBER;

Line 3211: FROM OKL_TRX_QUOTES_B qte

3207: l_transaction_source VARCHAR2(80);
3208: CURSOR c_set_trn_src
3209: IS
3210: SELECT 'TERMINATION_QUOTE' transaction_source
3211: FROM OKL_TRX_QUOTES_B qte
3212: WHERE qte.id = p_quote_id; --akrangan modified for bug 7036873
3213:
3214: BEGIN
3215: IF (is_debug_procedure_on) THEN

Line 3507: FROM okl_trx_quotes_b qte,

3503: qte.currency_conversion_date currency_conversion_date
3504: --PAGARG Bug 4044659 Query inventory org id
3505: ,khr.inv_organization_id inv_organization_id,
3506: qte.art_id -- RRAVIKIR Legal Entity Changes
3507: FROM okl_trx_quotes_b qte,
3508: fnd_lookups flo,
3509: okc_k_headers_b khr
3510: WHERE qte.id = cp_quote_id
3511: AND flo.lookup_type = 'OKL_QUOTE_TYPE'

Line 3569: FROM OKL_TRX_QUOTES_B qte,

3565: QTE.DATE_ACCEPTED DATE_ACCEPTED, -- RMUNJULU 4547765 FUTURE_BILLS_BUG
3566: qte.creation_date creation_date, --SECHAWLA 05-JAN-05 4926740 : added creation_date
3567: chr.inv_organization_id inv_organization_id,
3568: QTE.perdiem_amount -- rmunjulu LOANS_ENHACEMENTS
3569: FROM OKL_TRX_QUOTES_B qte,
3570: OKC_K_HEADERS_B chr
3571: WHERE qte.id = p_quote_id
3572: AND qte.khr_id = chr.id;-- rmunjulu 3985369
3573:

Line 4605: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE DEFAULT NULL;

4601:
4602: --+++++++++++ pagarg +++ Rollover +++++++ Start ++++++++++
4603: -- Following variables are used for creating counter
4604: -- invoices/credit memos for Rollover Quote
4605: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE DEFAULT NULL;
4606: l_qlt_mean fnd_lookups.meaning%TYPE := NULL;
4607: l_roll_allc_pos NUMBER;
4608: l_roll_allc_neg NUMBER;
4609: l_roll_taiv_rec taiv_rec_type;

Line 4623: FROM okl_trx_quotes_b

4619: -- Following cursor retrieves the quote type for the given quote id
4620: CURSOR quote_type_csr (p_quote_id IN NUMBER)
4621: IS
4622: SELECT qtp_code, khr_id
4623: FROM okl_trx_quotes_b
4624: WHERE id = p_quote_id;
4625:
4626: quote_type_rec quote_type_csr%rowtype;
4627:

Line 4658: FROM OKL_TRX_QUOTES_B qte,

4654: qte.khr_id khr_id,
4655: qte.date_effective_from date_eff_from,
4656: qte.date_accepted date_accepted,
4657: chr.inv_organization_id inv_organization_id
4658: FROM OKL_TRX_QUOTES_B qte,
4659: OKC_K_HEADERS_B chr
4660: WHERE qte.id = p_quote_id
4661: AND qte.khr_id = chr.id;
4662:

Line 4707: FROM okl_trx_quotes_b qte,

4703: qte.currency_conversion_type currency_conversion_type,
4704: qte.currency_conversion_rate currency_conversion_rate,
4705: qte.currency_conversion_date currency_conversion_date,
4706: khr.inv_organization_id inv_organization_id
4707: FROM okl_trx_quotes_b qte,
4708: fnd_lookups flo,
4709: okc_k_headers_b khr
4710: WHERE qte.id = cp_quote_id
4711: AND flo.lookup_type = 'OKL_QUOTE_TYPE'