DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 2912: CURSOR c_get_cashflow_object_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE)

2908: j BINARY_INTEGER := 0;
2909: lv_parent_object_code VARCHAR2(30);
2910: --Fix Bug # 5021724 ssdeshpa start
2911: --Cursor is not fetching the correct source cashflows;added where conditions.
2912: CURSOR c_get_cashflow_object_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE)
2913: IS
2914: SELECT ID
2915: FROM OKL_CASH_FLOW_OBJECTS
2916: WHERE SOURCE_ID = p_src_id

Line 2915: FROM OKL_CASH_FLOW_OBJECTS

2911: --Cursor is not fetching the correct source cashflows;added where conditions.
2912: CURSOR c_get_cashflow_object_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE)
2913: IS
2914: SELECT ID
2915: FROM OKL_CASH_FLOW_OBJECTS
2916: WHERE SOURCE_ID = p_src_id
2917: AND OTY_CODE = 'QUOTED_ASSET'
2918: AND SOURCE_TABLE='OKL_ASSETS_B';
2919: --Fix Bug # 5021724 ssdeshpa end

Line 4239: FROM OKL_CASH_FLOW_OBJECTS

4235:
4236: CURSOR c_check_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)
4237: IS
4238: SELECT 'YES'
4239: FROM OKL_CASH_FLOW_OBJECTS
4240: WHERE OTY_CODE = 'QUOTED_ASSET'
4241: AND SOURCE_TABLE = 'OKL_ASSETS_B'
4242: AND SOURCE_ID = p_asset_id;
4243: