[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'
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
822: AND asset.id = assetcomp.asset_id
823: AND assetcomp.PRIMARY_COMPONENT = 'YES'
1172: quote.product_id,
1173: leaseapp.SALES_REP_ID
1174: FROM
1175: okl_lease_quotes_b quote,
1176: okl_lease_applications_b leaseapp
1177: WHERE
1178: quote.id = p_quote_id
1179: AND quote.parent_object_id = leaseapp.id
1180: AND quote.parent_object_code = 'LEASEAPP';
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
1300: AND asset.id = assetcomp.asset_id
1301: AND assetcomp.PRIMARY_COMPONENT = 'YES'
1816: AND lsq.id = p_asset_rec.parent_object_id;
1817: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
1818: SELECT currency_code
1819: INTO l_currency_code
1820: FROM okl_lease_applications_b lap,
1821: okl_lease_quotes_b lsq
1822: WHERE lsq.parent_object_code = lv_parent_object_code
1823: AND lsq.parent_object_id = lap.id
1824: AND lsq.id = p_asset_rec.parent_object_id;