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 793: okl_lease_opportunities_b leaseopp

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

Line 1156: okl_lease_opportunities_b leaseopp

1152: quote.product_id,
1153: leaseopp.SALES_REP_ID
1154: FROM
1155: okl_lease_quotes_b quote,
1156: okl_lease_opportunities_b leaseopp
1157: WHERE
1158: quote.id = p_quote_id
1159: AND quote.parent_object_id = leaseopp.id
1160: AND quote.parent_object_code = 'LEASEOPP';

Line 1271: okl_lease_opportunities_b leaseopp

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

Line 1808: FROM okl_lease_opportunities_b lop,

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

Line 4611: FROM OKL_LEASE_OPPORTUNITIES_B LOP,

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