APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_LEASE_QUOTES_B

Line 15734: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)

15730: p_source_trx_name IN VARCHAR2,
15731: p_source_table IN VARCHAR2) IS
15732:
15733: ---------------------Sales Quote / Lease Application ----------------
15734: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)
15735: --p_source_trx_name ---> 'Sales Quote'
15736: --p_source_table ---> 'OKL_LEASE_QUOTES_B'
15737: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,
15738: -- as it will be the same for all the rows

Line 15736: --p_source_table ---> 'OKL_LEASE_QUOTES_B'

15732:
15733: ---------------------Sales Quote / Lease Application ----------------
15734: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)
15735: --p_source_trx_name ---> 'Sales Quote'
15736: --p_source_table ---> 'OKL_LEASE_QUOTES_B'
15737: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,
15738: -- as it will be the same for all the rows
15739: ----------------------------------------------------------------------
15740:

Line 15737: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,

15733: ---------------------Sales Quote / Lease Application ----------------
15734: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)
15735: --p_source_trx_name ---> 'Sales Quote'
15736: --p_source_table ---> 'OKL_LEASE_QUOTES_B'
15737: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,
15738: -- as it will be the same for all the rows
15739: ----------------------------------------------------------------------
15740:
15741: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 15748: FROM okl_lease_quotes_b

15744: CURSOR l_leasequotes_csr(cp_trx_id IN NUMBER) IS
15745: SELECT expected_start_date, product_id, interest_disclosed,
15746: transfer_of_title, sale_and_lease_back, purchase_of_lease, usage_category,
15747: age_of_equipment, parent_object_code , parent_object_id, legal_entity_id
15748: FROM okl_lease_quotes_b
15749: WHERE id = cp_trx_id;
15750:
15751: -- Get the transaction type id
15752: CURSOR l_trxtypes_csr IS

Line 15764: FROM okl_lease_opportunities_b lop, okl_lease_quotes_b lsq, okl_products pdt

15760: SELECT lop.currency_code, lop.cust_acct_id, lop.prospect_id, --> (party id)
15761: lop.org_id, lsq.expected_start_date, lop.currency_conversion_type,
15762: lop.currency_conversion_rate, lop.currency_conversion_date, lsq.line_intended_use,
15763: pdt.name
15764: FROM okl_lease_opportunities_b lop, okl_lease_quotes_b lsq, okl_products pdt
15765: WHERE lsq.parent_object_id = lop.id
15766: AND lsq.parent_object_code = 'LEASEOPP'
15767: AND lsq.product_id = pdt.id
15768: AND lsq.id = cp_id;

Line 15776: FROM okl_lease_applications_b lap, okl_lease_quotes_b lsq, okl_products pdt

15772: SELECT lap.currency_code, lap.cust_acct_id, lap.prospect_id, --> (party id)
15773: lap.org_id, lsq.expected_start_date, lap.currency_conversion_type,
15774: lap.currency_conversion_rate, lap.currency_conversion_date, lsq.line_intended_use,
15775: pdt.name
15776: FROM okl_lease_applications_b lap, okl_lease_quotes_b lsq, okl_products pdt
15777: WHERE lsq.parent_object_id = lap.id
15778: AND lsq.parent_object_code = 'LEASEAPP'
15779: AND lsq.primary_quote = 'Y'
15780: AND lsq.product_id = pdt.id

Line 15831: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'

15827: SELECT cfo.source_id , null, caf.sty_id,
15828: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15829: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15830: WHERE cfo.oty_code = 'LEASE_QUOTE'
15831: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
15832: AND cfo.source_id = cp_quote_id
15833: AND cfo.id = caf.cfo_id
15834: AND caf.cft_code = 'PAYMENT_SCHEDULE'
15835: AND caf.sts_code IN ('CURRENT', 'WORK')