DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_CASH_FLOWS

Line 2917: CURSOR c_get_cashflow_info(p_cfo_id OKL_CASH_FLOWS.CFO_ID%TYPE)

2913: AND OTY_CODE = 'QUOTED_ASSET'
2914: AND SOURCE_TABLE='OKL_ASSETS_B';
2915: --Fix Bug # 5021724 ssdeshpa end
2916:
2917: CURSOR c_get_cashflow_info(p_cfo_id OKL_CASH_FLOWS.CFO_ID%TYPE)
2918: IS
2919: SELECT CFLOW.ID, CFLOW.STY_ID, CFLOW.DUE_ARREARS_YN, CFLOW.CFT_CODE, STRMTYP.STREAM_TYPE_PURPOSE
2920: FROM OKL_CASH_FLOWS CFLOW,
2921: OKL_STRMTYP_SOURCE_V STRMTYP

Line 2920: FROM OKL_CASH_FLOWS CFLOW,

2916:
2917: CURSOR c_get_cashflow_info(p_cfo_id OKL_CASH_FLOWS.CFO_ID%TYPE)
2918: IS
2919: SELECT CFLOW.ID, CFLOW.STY_ID, CFLOW.DUE_ARREARS_YN, CFLOW.CFT_CODE, STRMTYP.STREAM_TYPE_PURPOSE
2920: FROM OKL_CASH_FLOWS CFLOW,
2921: OKL_STRMTYP_SOURCE_V STRMTYP
2922: WHERE CFO_ID = p_cfo_id
2923: AND CFLOW.STY_ID = STRMTYP.ID1;
2924:

Line 2925: CURSOR c_get_cashflow_levels(p_caf_id OKL_CASH_FLOWS.ID%TYPE)

2921: OKL_STRMTYP_SOURCE_V STRMTYP
2922: WHERE CFO_ID = p_cfo_id
2923: AND CFLOW.STY_ID = STRMTYP.ID1;
2924:
2925: CURSOR c_get_cashflow_levels(p_caf_id OKL_CASH_FLOWS.ID%TYPE)
2926: IS
2927: SELECT AMOUNT, NUMBER_OF_PERIODS, FQY_CODE, STUB_DAYS, STUB_AMOUNT
2928: FROM OKL_CASH_FLOW_LEVELS
2929: WHERE CAF_ID = p_caf_id;