APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 28: FROM okl_cost_adjustments_b costadj,

24: l_api_name CONSTANT VARCHAR2(30) := 'sync_tradein_description';
25:
26: cursor adj_csr is
27: SELECT costadj.id
28: FROM okl_cost_adjustments_b costadj,
29: okl_assets_b asset
30: WHERE costadj.adjustment_source_type = 'TRADEIN'
31: AND costadj.parent_object_id = asset.id
32: AND costadj.parent_object_code = 'ASSET'

Line 36: type rowid_tbl is table of okl_cost_adjustments_b.ID%TYPE

32: AND costadj.parent_object_code = 'ASSET'
33: AND asset.parent_object_id = p_quote_id
34: AND asset.parent_object_code = 'LEASEQUOTE';
35:
36: type rowid_tbl is table of okl_cost_adjustments_b.ID%TYPE
37: index by binary_integer ;
38: l_rowid_tbl rowid_tbl;
39: L_FETCH_SIZE NUMBER := 5000;
40: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1537: FROM OKL_COST_ADJUSTMENTS_B

1533: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1534:
1535: CURSOR c_check_asset_adj (p_asset_id IN NUMBER, p_adj_type IN VARCHAR2) IS
1536: SELECT 'Y'
1537: FROM OKL_COST_ADJUSTMENTS_B
1538: WHERE PARENT_OBJECT_ID = p_asset_id
1539: AND PARENT_OBJECT_CODE = 'ASSET'
1540: AND ADJUSTMENT_SOURCE_TYPE = p_adj_type;
1541:

Line 1663: FROM okl_cost_adjustments_b costadj,

1659: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1660:
1661: CURSOR c_db_adj_assets IS
1662: SELECT costadj.id, costadj.parent_object_id
1663: FROM okl_cost_adjustments_b costadj,
1664: okl_assets_b asset
1665: WHERE costadj.adjustment_source_type = p_adj_type
1666: AND costadj.parent_object_id = asset.id
1667: AND costadj.parent_object_code = 'ASSET'

Line 1673: FROM okl_cost_adjustments_b costadj,

1669: AND asset.parent_object_code = 'LEASEQUOTE';
1670:
1671: CURSOR c_db_subs_assets(p_adj_source_id IN NUMBER) IS
1672: SELECT costadj.id, costadj.parent_object_id
1673: FROM okl_cost_adjustments_b costadj,
1674: okl_assets_b asset
1675: WHERE costadj.adjustment_source_type = p_adj_type
1676: AND costadj.adjustment_source_id = p_adj_source_id
1677: AND costadj.parent_object_id = asset.id

Line 2091: x_asset_id okl_cost_adjustments_b.adjustment_source_id%type;

2087: l_p_code VARCHAR2(30);
2088: lb_validate_subsidy_usage BOOLEAN;
2089:
2090: asset_adj_defined VARCHAR2(1) := 'N';
2091: x_asset_id okl_cost_adjustments_b.adjustment_source_id%type;
2092: lv_asset_number okl_assets_b.asset_number%TYPE;
2093: ln_index NUMBER;
2094:
2095: --Bug 7291307 : Adding starts

Line 2733: FROM okl_cost_adjustments_b costadj,

2729: l_p_code VARCHAR2(30);
2730:
2731: CURSOR c_db_adj_assets IS
2732: SELECT costadj.id, costadj.adjustment_source_id
2733: FROM okl_cost_adjustments_b costadj,
2734: okl_assets_b asset
2735: WHERE costadj.adjustment_source_type = p_adjustment_type
2736: AND costadj.parent_object_id = asset.id
2737: AND costadj.parent_object_code = 'ASSET'

Line 2743: FROM okl_cost_adjustments_b costadj

2739: AND asset.parent_object_code = 'LEASEQUOTE';
2740:
2741: CURSOR c_db_adj_asset(p_asset_id IN NUMBER) IS
2742: SELECT costadj.id,costadj.adjustment_source_type,costadj.processing_type,costadj.stream_type_id
2743: FROM okl_cost_adjustments_b costadj
2744: WHERE costadj.adjustment_source_type = p_adjustment_type
2745: AND costadj.parent_object_id = p_asset_id
2746: AND costadj.parent_object_code = 'ASSET';
2747: BEGIN