APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 359: FROM okl_lease_opportunities_b lop,

355: END IF;
356: IF (lv_parent_object_code = 'LEASEOPP') THEN
357: SELECT currency_code
358: INTO l_currency_code
359: FROM okl_lease_opportunities_b lop,
360: okl_lease_quotes_b lsq
361: WHERE lsq.parent_object_code = lv_parent_object_code
362: AND lsq.parent_object_id = lop.id
363: AND lsq.id = l_quote_id;

Line 628: okl_lease_opportunities_b leaseopp

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
631: AND asset.id = assetcomp.asset_id
632: AND assetcomp.PRIMARY_COMPONENT = 'YES'

Line 797: okl_lease_opportunities_b leaseopp

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
800: AND asset.id = assetcomp.asset_id
801: AND assetcomp.PRIMARY_COMPONENT = 'YES'

Line 1160: okl_lease_opportunities_b leaseopp

1156: quote.product_id,
1157: leaseopp.SALES_REP_ID
1158: FROM
1159: okl_lease_quotes_b quote,
1160: okl_lease_opportunities_b leaseopp
1161: WHERE
1162: quote.id = p_quote_id
1163: AND quote.parent_object_id = leaseopp.id
1164: AND quote.parent_object_code = 'LEASEOPP';

Line 1275: okl_lease_opportunities_b leaseopp

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
1278: AND asset.id = assetcomp.asset_id
1279: AND assetcomp.PRIMARY_COMPONENT = 'YES'

Line 1812: FROM okl_lease_opportunities_b lop,

1808:
1809: IF (lv_parent_object_code = 'LEASEOPP') THEN
1810: SELECT currency_code
1811: INTO l_currency_code
1812: FROM okl_lease_opportunities_b lop,
1813: okl_lease_quotes_b lsq
1814: WHERE lsq.parent_object_code = lv_parent_object_code
1815: AND lsq.parent_object_id = lop.id
1816: AND lsq.id = p_asset_rec.parent_object_id;

Line 4615: FROM OKL_LEASE_OPPORTUNITIES_B LOP,

4611: ln_index NUMBER;
4612:
4613: CURSOR c_get_supplier_id(p_qte_id IN OKL_LEASE_QUOTES_B.ID%TYPE) IS
4614: SELECT LOP.SUPPLIER_ID supplier_id
4615: FROM OKL_LEASE_OPPORTUNITIES_B LOP,
4616: OKL_LEASE_QUOTES_B QTE
4617: WHERE LOP.ID = QTE.parent_object_id
4618: AND qte.id = p_qte_id;
4619: