APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_ASSETS_B

Line 446: OKL_ASSETS_B AST

442: l_ast_cnt NUMBER;
443: CURSOR llo_flag_csr IS
444: SELECT count(*) overriden_assets_count
445: FROM OKL_LEASE_QUOTES_B QTE,
446: OKL_ASSETS_B AST
447: WHERE AST.PARENT_OBJECT_ID = QTE.ID
448: AND ( AST.RATE_TEMPLATE_ID IS NOT NULL
449: OR AST.STRUCTURED_PRICING = 'Y' )
450: AND QTE.ID = p_quote_id

Line 456: OKL_ASSETS_B AST

452:
453: CURSOR rc_llo_flag_csr IS
454: SELECT count(*) overriden_assets_count
455: FROM OKL_LEASE_QUOTES_B QTE,
456: OKL_ASSETS_B AST
457: WHERE AST.PARENT_OBJECT_ID = QTE.ID
458: AND ( AST.RATE_CARD_ID IS NOT NULL
459: OR AST.LEASE_RATE_FACTOR IS NOT NULL )
460: AND QTE.ID = p_quote_id

Line 466: OKL_ASSETS_B AST

462:
463: CURSOR sy_llo_flag_csr IS
464: SELECT count(*) overriden_assets_count
465: FROM OKL_LEASE_QUOTES_B QTE,
466: OKL_ASSETS_B AST
467: WHERE AST.PARENT_OBJECT_ID = QTE.ID
468: AND ( AST.STRUCTURED_PRICING = 'Y')
469: AND QTE.ID = p_quote_id
470: AND p_line_level_pricing = 'Y';

Line 475: OKL_ASSETS_B AST

471:
472: CURSOR ast_cnt_csr IS
473: SELECT count(*) assets_count
474: FROM OKL_LEASE_QUOTES_B QTE,
475: OKL_ASSETS_B AST
476: WHERE AST.PARENT_OBJECT_ID = QTE.ID
477: AND QTE.ID = p_quote_id;
478:
479: BEGIN

Line 1146: FROM OKL_ASSETS_B

1142: AND SOURCE_ID = p_quote_id;
1143:
1144: CURSOR quote_assets_csr(lc_quote_id IN NUMBER) IS
1145: SELECT ID
1146: FROM OKL_ASSETS_B
1147: WHERE parent_object_id = lc_quote_id
1148: AND parent_object_code = 'LEASEQUOTE';
1149:
1150: CURSOR quote_fees_csr(lc_quote_id IN NUMBER) IS

Line 1495: FROM OKL_ASSETS_B

1491: l_entered VARCHAR2(3);
1492:
1493: CURSOR quote_assets_csr(lc_quote_id IN NUMBER) IS
1494: SELECT ID
1495: FROM OKL_ASSETS_B
1496: WHERE parent_object_id = lc_quote_id
1497: AND parent_object_code = 'LEASEQUOTE';
1498:
1499: CURSOR quote_fees_csr(lc_quote_id IN NUMBER) IS

Line 1789: CURSOR c_check_asset_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)

1785: lv_cash_flow_exists VARCHAR2(3);
1786: l_p_id NUMBER;
1787: l_p_code VARCHAR2(30);
1788:
1789: CURSOR c_check_asset_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)
1790: IS
1791: SELECT 'YES'
1792: FROM OKL_CASH_FLOW_OBJECTS
1793: WHERE OTY_CODE = 'QUOTED_ASSET'

Line 1794: AND SOURCE_TABLE = 'OKL_ASSETS_B'

1790: IS
1791: SELECT 'YES'
1792: FROM OKL_CASH_FLOW_OBJECTS
1793: WHERE OTY_CODE = 'QUOTED_ASSET'
1794: AND SOURCE_TABLE = 'OKL_ASSETS_B'
1795: AND SOURCE_ID = p_asset_id;
1796:
1797: CURSOR c_check_fee_cash_flow(p_fee_id OKL_FEES_B.ID%TYPE)
1798: IS