APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_LEASE_QUOTES_B

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

15658: p_source_trx_name IN VARCHAR2,
15659: p_source_table IN VARCHAR2) IS
15660:
15661: ---------------------Sales Quote / Lease Application ----------------
15662: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)
15663: --p_source_trx_name ---> 'Sales Quote'
15664: --p_source_table ---> 'OKL_LEASE_QUOTES_B'
15665: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,
15666: -- as it will be the same for all the rows

Line 15664: --p_source_table ---> 'OKL_LEASE_QUOTES_B'

15660:
15661: ---------------------Sales Quote / Lease Application ----------------
15662: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)
15663: --p_source_trx_name ---> 'Sales Quote'
15664: --p_source_table ---> 'OKL_LEASE_QUOTES_B'
15665: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,
15666: -- as it will be the same for all the rows
15667: ----------------------------------------------------------------------
15668:

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

15661: ---------------------Sales Quote / Lease Application ----------------
15662: --p_source_trx_id ---> okl_lease_quotes_b.id (sales quote ID)
15663: --p_source_trx_name ---> 'Sales Quote'
15664: --p_source_table ---> 'OKL_LEASE_QUOTES_B'
15665: -- 'Sales Quote' is not going to store/add try_id in okl_lease_quotes_b,
15666: -- as it will be the same for all the rows
15667: ----------------------------------------------------------------------
15668:
15669: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 15676: FROM okl_lease_quotes_b

15672: CURSOR l_leasequotes_csr(cp_trx_id IN NUMBER) IS
15673: SELECT expected_start_date, product_id, interest_disclosed,
15674: transfer_of_title, sale_and_lease_back, purchase_of_lease, usage_category,
15675: age_of_equipment, parent_object_code , parent_object_id, legal_entity_id
15676: FROM okl_lease_quotes_b
15677: WHERE id = cp_trx_id;
15678:
15679: -- Get the transaction type id
15680: CURSOR l_trxtypes_csr IS

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

15688: SELECT lop.currency_code, lop.cust_acct_id, lop.prospect_id, --> (party id)
15689: lop.org_id, lsq.expected_start_date, lop.currency_conversion_type,
15690: lop.currency_conversion_rate, lop.currency_conversion_date, lsq.line_intended_use,
15691: pdt.name
15692: FROM okl_lease_opportunities_b lop, okl_lease_quotes_b lsq, okl_products pdt
15693: WHERE lsq.parent_object_id = lop.id
15694: AND lsq.parent_object_code = 'LEASEOPP'
15695: AND lsq.product_id = pdt.id
15696: AND lsq.id = cp_id;

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

15700: SELECT lap.currency_code, lap.cust_acct_id, lap.prospect_id, --> (party id)
15701: lap.org_id, lsq.expected_start_date, lap.currency_conversion_type,
15702: lap.currency_conversion_rate, lap.currency_conversion_date, lsq.line_intended_use,
15703: pdt.name
15704: FROM okl_lease_applications_b lap, okl_lease_quotes_b lsq, okl_products pdt
15705: WHERE lsq.parent_object_id = lap.id
15706: AND lsq.parent_object_code = 'LEASEAPP'
15707: AND lsq.primary_quote = 'Y'
15708: AND lsq.product_id = pdt.id

Line 15759: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'

15755: SELECT cfo.source_id , null, caf.sty_id,
15756: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15757: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15758: WHERE cfo.oty_code = 'LEASE_QUOTE'
15759: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
15760: AND cfo.source_id = cp_quote_id
15761: AND cfo.id = caf.cfo_id
15762: AND caf.cft_code = 'PAYMENT_SCHEDULE'
15763: AND caf.sts_code IN ('CURRENT', 'WORK')