DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_CASH_FLOW_OBJECTS

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

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

Line 2911: FROM OKL_CASH_FLOW_OBJECTS

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

Line 4235: FROM OKL_CASH_FLOW_OBJECTS

4231:
4232: CURSOR c_check_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)
4233: IS
4234: SELECT 'YES'
4235: FROM OKL_CASH_FLOW_OBJECTS
4236: WHERE OTY_CODE = 'QUOTED_ASSET'
4237: AND SOURCE_TABLE = 'OKL_ASSETS_B'
4238: AND SOURCE_ID = p_asset_id;
4239: