DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_CASH_FLOWS

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

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

Line 2924: FROM OKL_CASH_FLOWS CFLOW,

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

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

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