APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_ASSET_COMPONENTS_B

Line 626: okl_asset_components_b assetcomp,

622: quote.product_id,
623: leaseopp.SALES_REP_ID
624: FROM
625: okl_assets_b asset,
626: okl_asset_components_b assetcomp,
627: okl_lease_quotes_b quote,
628: okl_lease_opportunities_b leaseopp
629: WHERE
630: asset.id = p_asset_id

Line 648: okl_asset_components_b assetcomp,

644: quote.product_id,
645: leaseapp.SALES_REP_ID
646: FROM
647: okl_assets_b asset,
648: okl_asset_components_b assetcomp,
649: okl_lease_quotes_b quote,
650: okl_lease_applications_b leaseapp
651: WHERE
652: asset.id = p_asset_id

Line 791: okl_asset_components_b assetcomp,

787: quote.product_id,
788: leaseopp.SALES_REP_ID
789: FROM
790: okl_assets_b asset,
791: okl_asset_components_b assetcomp,
792: okl_lease_quotes_b quote,
793: okl_lease_opportunities_b leaseopp
794: WHERE
795: asset.id = p_asset_id

Line 813: okl_asset_components_b assetcomp,

809: quote.product_id,
810: leaseapp.SALES_REP_ID
811: FROM
812: okl_assets_b asset,
813: okl_asset_components_b assetcomp,
814: okl_lease_quotes_b quote,
815: okl_lease_applications_b leaseapp
816: WHERE
817: asset.id = p_asset_id

Line 1181: okl_asset_components_b assetcomp

1177:
1178: CURSOR c_get_inv_items IS
1179: SELECT assetcomp.INV_ITEM_ID
1180: FROM okl_assets_b asset,
1181: okl_asset_components_b assetcomp
1182: WHERE
1183: asset.id = assetcomp.asset_id
1184: AND assetcomp.PRIMARY_COMPONENT = 'YES'
1185: AND asset.parent_object_id = p_quote_id

Line 1269: okl_asset_components_b assetcomp,

1265: quote.product_id,
1266: leaseopp.SALES_REP_ID
1267: FROM
1268: okl_assets_b asset,
1269: okl_asset_components_b assetcomp,
1270: okl_lease_quotes_b quote,
1271: okl_lease_opportunities_b leaseopp
1272: WHERE
1273: asset.id = p_asset_id

Line 1291: okl_asset_components_b assetcomp,

1287: quote.product_id,
1288: leaseapp.SALES_REP_ID
1289: FROM
1290: okl_assets_b asset,
1291: okl_asset_components_b assetcomp,
1292: okl_lease_quotes_b quote,
1293: okl_lease_applications_b leaseapp
1294: WHERE
1295: asset.id = p_asset_id

Line 1469: FROM okl_asset_components_b

1465: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1466:
1467: CURSOR c_db_addons IS
1468: SELECT id
1469: FROM okl_asset_components_b
1470: WHERE asset_id = p_asset_id
1471: AND primary_component = 'NO';
1472:
1473: l_addon_tbl component_tbl_type;

Line 4054: FROM OKL_ASSET_COMPONENTS_B

4050: -- Cursors to check the existence of asset information
4051: CURSOR c_get_asset_components(p_asset_id OKL_ASSETS_B.ID%TYPE)
4052: IS
4053: SELECT ID
4054: FROM OKL_ASSET_COMPONENTS_B
4055: WHERE ASSET_ID = p_asset_id;
4056:
4057: CURSOR c_get_line_relationships(p_asset_id OKL_ASSETS_B.ID%TYPE)
4058: IS