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 1541: FROM OKL_COST_ADJUSTMENTS_B

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

Line 1667: FROM okl_cost_adjustments_b costadj,

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

Line 1677: FROM okl_cost_adjustments_b costadj,

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

Line 2095: x_asset_id okl_cost_adjustments_b.adjustment_source_id%type;

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

Line 2737: FROM okl_cost_adjustments_b costadj,

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

Line 2747: FROM okl_cost_adjustments_b costadj

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