[Home] [Help]
363: AND lsq.id = l_quote_id;
364: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
365: SELECT currency_code
366: INTO l_currency_code
367: FROM okl_lease_applications_b lap,
368: okl_lease_quotes_b lsq
369: WHERE lsq.parent_object_code = lv_parent_object_code
370: AND lsq.parent_object_id = lap.id
371: AND lsq.id = l_quote_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
653: AND asset.id = assetcomp.asset_id
654: AND assetcomp.PRIMARY_COMPONENT = 'YES'
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
818: AND asset.id = assetcomp.asset_id
819: AND assetcomp.PRIMARY_COMPONENT = 'YES'
1168: quote.product_id,
1169: leaseapp.SALES_REP_ID
1170: FROM
1171: okl_lease_quotes_b quote,
1172: okl_lease_applications_b leaseapp
1173: WHERE
1174: quote.id = p_quote_id
1175: AND quote.parent_object_id = leaseapp.id
1176: AND quote.parent_object_code = 'LEASEAPP';
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
1296: AND asset.id = assetcomp.asset_id
1297: AND assetcomp.PRIMARY_COMPONENT = 'YES'
1812: AND lsq.id = p_asset_rec.parent_object_id;
1813: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
1814: SELECT currency_code
1815: INTO l_currency_code
1816: FROM okl_lease_applications_b lap,
1817: okl_lease_quotes_b lsq
1818: WHERE lsq.parent_object_code = lv_parent_object_code
1819: AND lsq.parent_object_id = lap.id
1820: AND lsq.id = p_asset_rec.parent_object_id;