DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_CASH_FLOWS

Line 239: FROM OKL_CASH_FLOWS cf,

235: RETURN VARCHAR2 IS
236: -- Cursor to fetch cashflow header id
237: CURSOR lq_cash_flows_csr(p_quote_id NUMBER) IS
238: SELECT cf.id caf_id
239: FROM OKL_CASH_FLOWS cf,
240: OKL_CASH_FLOW_OBJECTS cfo
241: WHERE cf.cfo_id = cfo.id
242: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
243: AND cfo.source_id = p_quote_id;

Line 3089: FROM OKL_CASH_FLOWS CFLOW, OKL_CASH_FLOW_OBJECTS CFO

3085: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE
3086: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)
3087: IS
3088: SELECT CFLOW.ID , CFLOW.OBJECT_VERSION_NUMBER
3089: FROM OKL_CASH_FLOWS CFLOW, OKL_CASH_FLOW_OBJECTS CFO
3090: WHERE CFO.SOURCE_ID = p_src_id
3091: AND CFO.OTY_CODE = p_oty_code
3092: AND CFO.SOURCE_TABLE=p_source_table
3093: AND CFLOW.CFO_ID = CFO.ID;