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 795: okl_asset_components_b assetcomp,

791: quote.product_id,
792: leaseopp.SALES_REP_ID
793: FROM
794: okl_assets_b asset,
795: okl_asset_components_b assetcomp,
796: okl_lease_quotes_b quote,
797: okl_lease_opportunities_b leaseopp
798: WHERE
799: asset.id = p_asset_id

Line 817: okl_asset_components_b assetcomp,

813: quote.product_id,
814: leaseapp.SALES_REP_ID
815: FROM
816: okl_assets_b asset,
817: okl_asset_components_b assetcomp,
818: okl_lease_quotes_b quote,
819: okl_lease_applications_b leaseapp
820: WHERE
821: asset.id = p_asset_id

Line 1185: okl_asset_components_b assetcomp

1181:
1182: CURSOR c_get_inv_items IS
1183: SELECT assetcomp.INV_ITEM_ID
1184: FROM okl_assets_b asset,
1185: okl_asset_components_b assetcomp
1186: WHERE
1187: asset.id = assetcomp.asset_id
1188: AND assetcomp.PRIMARY_COMPONENT = 'YES'
1189: AND asset.parent_object_id = p_quote_id

Line 1273: okl_asset_components_b assetcomp,

1269: quote.product_id,
1270: leaseopp.SALES_REP_ID
1271: FROM
1272: okl_assets_b asset,
1273: okl_asset_components_b assetcomp,
1274: okl_lease_quotes_b quote,
1275: okl_lease_opportunities_b leaseopp
1276: WHERE
1277: asset.id = p_asset_id

Line 1295: okl_asset_components_b assetcomp,

1291: quote.product_id,
1292: leaseapp.SALES_REP_ID
1293: FROM
1294: okl_assets_b asset,
1295: okl_asset_components_b assetcomp,
1296: okl_lease_quotes_b quote,
1297: okl_lease_applications_b leaseapp
1298: WHERE
1299: asset.id = p_asset_id

Line 1473: FROM okl_asset_components_b

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

Line 4058: FROM OKL_ASSET_COMPONENTS_B

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