APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_ASSETS_B

Line 444: OKL_ASSETS_B AST

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

Line 454: OKL_ASSETS_B AST

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

Line 464: OKL_ASSETS_B AST

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

Line 473: OKL_ASSETS_B AST

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

Line 1144: FROM OKL_ASSETS_B

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

Line 1493: FROM OKL_ASSETS_B

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

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

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

Line 1792: AND SOURCE_TABLE = 'OKL_ASSETS_B'

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