APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_QUICK_QUOTE_LINES_B

Line 460: FROM OKL_QUICK_QUOTE_LINES_B qql

456: SELECT value
457: ,basis
458: ,nvl(nvl(end_of_term_value, end_of_term_value_default), 0) end_of_term_amount
459: ,percentage_of_total_cost
460: FROM OKL_QUICK_QUOTE_LINES_B qql
461: WHERE qql.quick_quote_id = p_qq_id
462: AND TYPE = G_ITEMCATEGORY_TYPE; -- Item Category Type
463: -- Cursor to fetch the EOT Type
464: CURSOR get_eot_type( p_qq_id NUMBER )

Line 758: FROM OKL_QUICK_QUOTE_LINES_B qql

754: IS
755: SELECT type
756: ,basis
757: ,value
758: FROM OKL_QUICK_QUOTE_LINES_B qql
759: WHERE qql.quick_quote_id = p_qq_id
760: AND TYPE IN ( G_DOWNPAYMENT_TYPE, -- Down Payment Type
761: G_TRADEIN_TYPE, -- Trade in Type
762: G_SUBSIDY_TYPE -- Subsidy Type

Line 1419: FROM OKL_QUICK_QUOTE_LINES_B qql

1415: SELECT qql.id qq_line_id
1416: ,qql.type type
1417: ,qql.basis basis
1418: ,qql.value value
1419: FROM OKL_QUICK_QUOTE_LINES_B qql
1420: WHERE qql.quick_quote_id = p_qq_id
1421: AND TYPE IN (G_QQ_FEE_EXPENSE,
1422: G_QQ_FEE_PAYMENT)
1423: ORDER BY TYPE;

Line 1441: AND cfo.source_table = 'OKL_QUICK_QUOTE_LINES_B'

1437: ,oty_code oty_code
1438: FROM OKL_CASH_FLOWS cf,
1439: OKL_CASH_FLOW_OBJECTS cfo
1440: WHERE cf.cfo_id = cfo.id
1441: AND cfo.source_table = 'OKL_QUICK_QUOTE_LINES_B'
1442: AND cfo.source_id = p_qq_line_id;
1443: -- Cursor to fetch the Cash Flow Details
1444: CURSOR qq_cash_flow_levels_csr( p_caf_id NUMBER )
1445: IS

Line 5988: FROM OKL_QUICK_QUOTE_LINES_B qql

5984: ,value
5985: ,basis
5986: ,nvl(nvl(end_of_term_value, end_of_term_value_default), 0) end_of_term_amount
5987: ,lease_rate_factor
5988: FROM OKL_QUICK_QUOTE_LINES_B qql
5989: WHERE qql.quick_quote_id = p_qq_id
5990: AND TYPE = G_ITEMCATEGORY_TYPE; -- Item Category Type
5991:
5992: CURSOR get_cat_name(p_category_id IN NUMBER) IS

Line 6007: FROM OKL_QUICK_QUOTE_LINES_B qql

6003: ,SUM(CASE basis
6004: WHEN 'FIXED' THEN value
6005: WHEN 'ASSET_COST' THEN value * p_tot_item_cost * .01
6006: END ) AS fin_value
6007: FROM OKL_QUICK_QUOTE_LINES_B qql
6008: WHERE qql.quick_quote_id = p_qq_id
6009: AND TYPE IN ( G_DOWNPAYMENT_TYPE, -- Down Payment Type
6010: G_TRADEIN_TYPE, -- Trade in Type
6011: G_SUBSIDY_TYPE ) -- Subsidy Type

Line 6267: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.

6263: -- Note:
6264: -- When user hasn't picked the LRS for Rate Card pricing and wishes
6265: -- to enter the LRF .. ie. Structured Pricing, Suresh PB has confirmed
6266: -- that irrespective of the line level pricing has been checked or not
6267: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.
6268: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and
6269: -- then build the cash flows from that ..
6270: -- Get the Months factor!
6271: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

Line 6268: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and

6264: -- When user hasn't picked the LRS for Rate Card pricing and wishes
6265: -- to enter the LRF .. ie. Structured Pricing, Suresh PB has confirmed
6266: -- that irrespective of the line level pricing has been checked or not
6267: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.
6268: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and
6269: -- then build the cash flows from that ..
6270: -- Get the Months factor!
6271: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
6272: p_frequency => p_qq_hdr_rec.target_frequency,

Line 6412: FROM OKL_QUICK_QUOTE_LINES_B qql

6408: -- Cursor Declarations
6409: CURSOR get_deal_size_csr( p_qq_id NUMBER )
6410: IS
6411: SELECT sum(VALUE) deal_size
6412: FROM OKL_QUICK_QUOTE_LINES_B qql
6413: WHERE qql.quick_quote_id = p_qq_id
6414: AND qql.TYPE = G_ITEMCATEGORY_TYPE; -- Item Category Type
6415: -- Local Variables declaration
6416: l_cash_flow_rec so_cash_flows_rec_type;