[Home] [Help]
29: SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
30: WHERE t1.id = p_quote_id;
31:
32: CURSOR c_lq_header_rec(p_quote_id NUMBER) IS
33: SELECT t1.* FROM OKL_LEASE_QUOTES_B t1
34: WHERE t1.id = p_quote_id;
35:
36: lp_qq_header_rec c_qq_header_rec%ROWTYPE;
37: lp_lq_header_rec c_lq_header_rec%ROWTYPE;
151: l_adj_amount NUMBER;
152: --Bug # 5050143 ssdeshpa end
153: CURSOR c_lq_rec(p_lease_quote_id NUMBER) IS
154: SELECT *
155: FROM OKL_LEASE_QUOTES_B
156: where id=p_lease_quote_id;
157: l_lq_rec c_lq_rec%ROWTYPE;
158:
159: CURSOR c_lop_rec(p_parent_object_id NUMBER) IS
193:
194: --Added Cursors to get Deal Size of LQ
195: CURSOR c_deal_size_cur(p_parent_object_id NUMBER) IS
196: select SUM(OEC)
197: FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
198: where OAB.PARENT_OBJECT_ID = OLQ.ID
199: AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
200: AND OLQ.ID= p_parent_object_id;
201: --Added Cursors to get Adjustment(DN,Trade In Subsidy) for LQ
943: l_ovr_cnt NUMBER;
944: l_ast_cnt NUMBER;
945: CURSOR llo_flag_csr IS
946: SELECT count(*) overriden_assets_count
947: FROM OKL_LEASE_QUOTES_B QTE,
948: OKL_ASSETS_B AST
949: WHERE AST.PARENT_OBJECT_ID = QTE.ID
950: AND ( AST.RATE_TEMPLATE_ID IS NOT NULL
951: OR AST.STRUCTURED_PRICING = 'Y' )
953: AND p_line_level_pricing = 'Y';
954:
955: CURSOR rc_llo_flag_csr IS
956: SELECT count(*) overriden_assets_count
957: FROM OKL_LEASE_QUOTES_B QTE,
958: OKL_ASSETS_B AST
959: WHERE AST.PARENT_OBJECT_ID = QTE.ID
960: AND ( AST.RATE_CARD_ID IS NOT NULL
961: OR AST.LEASE_RATE_FACTOR IS NOT NULL )
963: AND p_line_level_pricing = 'Y';
964:
965: CURSOR sy_llo_flag_csr IS
966: SELECT count(*) overriden_assets_count
967: FROM OKL_LEASE_QUOTES_B QTE,
968: OKL_ASSETS_B AST
969: WHERE AST.PARENT_OBJECT_ID = QTE.ID
970: AND ( AST.STRUCTURED_PRICING = 'Y')
971: AND QTE.ID = p_quote_id
972: AND p_line_level_pricing = 'Y';
973:
974: CURSOR ast_cnt_csr IS
975: SELECT count(*) assets_count
976: FROM OKL_LEASE_QUOTES_B QTE,
977: OKL_ASSETS_B AST
978: WHERE AST.PARENT_OBJECT_ID = QTE.ID
979: AND QTE.ID = p_quote_id;
980:
1453: is_debug_statement_on boolean;
1454: cursor c_lq_asset_lines_rec(p_lease_quote_id NUMBER) IS
1455: --select SUM(NVL(OEC_PERCENTAGE,0))
1456: select oec_percentage
1457: from OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
1458: WHERE OLQ.PRICING_METHOD= 'SF'
1459: AND OAB.parent_object_code='LEASEQUOTE'
1460: AND OAB.parent_object_id = OLQ.id
1461: AND OLQ.id= p_lease_quote_id;
2659: lp_qq_asset_lines_rec c_qq_asset_lines_rec%ROWTYPE;
2660:
2661: cursor c_lq_asset_lines_rec(p_quote_id NUMBER) IS
2662: SELECT t2.*
2663: FROM OKL_LEASE_QUOTES_B t1,OKL_ASSETS_B t2
2664: where t1.id=p_quote_id
2665: AND t1.pricing_method='SF'
2666: and t2.parent_object_code='LEASEQUOTE'
2667: and t2.parent_object_id=t1.id;
4584: --Bug # 5070686 ssdeshpa end;
4585: -------------------------------------------------------------------------------
4586: --Any Payment should not have start date earlier than the Quote Expected Start Date
4587: select TRUNC(EXPECTED_START_DATE) INTO lp_cont_start_date
4588: from OKL_LEASE_QUOTES_B
4589: WHERE ID=lp_quote_id;
4590: ---Check for the VPA Effective Dates Fall within the Expected Start Date
4591: IF(lp_vp_id IS NOT NULL) THEN
4592: OPEN c_vp_rec(lp_vp_id ,lp_cont_start_date);
4753:
4754: CURSOR c_get_lq_rec(p_parent_object_id NUMBER,
4755: p_object_type VARCHAR2) IS
4756: SELECT OLQ.ID
4757: FROM OKL_LEASE_QUOTES_B OLQ
4758: WHERE PARENT_OBJECT_ID=p_parent_object_id
4759: AND PARENT_OBJECT_CODE=p_object_type
4760: AND PRIMARY_QUOTE='Y';
4761:
5352:
5353: CURSOR get_lq_rec(p_parent_object_id NUMBER,
5354: p_object_type VARCHAR2) IS
5355: SELECT OLQ.ID
5356: FROM OKL_LEASE_QUOTES_B OLQ
5357: WHERE PARENT_OBJECT_ID=p_parent_object_id
5358: AND PARENT_OBJECT_CODE=p_object_type
5359: AND PRIMARY_QUOTE='Y';
5360: