APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 240: OKL_CASH_FLOW_OBJECTS cfo

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;
244:

Line 1518: FROM OKL_CASH_FLOW_OBJECTS

1514: lv_chk_payment VARCHAR2(1);
1515:
1516: CURSOR c_chk_payments IS
1517: SELECT 'Y'
1518: FROM OKL_CASH_FLOW_OBJECTS
1519: WHERE SOURCE_ID = p_source_quote_id
1520: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1521: AND OTY_CODE = 'LEASE_QUOTE';
1522:

Line 1525: FROM OKL_CASH_FLOW_OBJECTS

1521: AND OTY_CODE = 'LEASE_QUOTE';
1522:
1523: CURSOR c_chk_payments_cons IS
1524: SELECT 'Y'
1525: FROM OKL_CASH_FLOW_OBJECTS
1526: WHERE SOURCE_ID = p_source_quote_id
1527: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1528: AND OTY_CODE = 'LEASE_QUOTE_CONSOLIDATED';
1529:

Line 3084: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE

3080: ,x_msg_count OUT NOCOPY NUMBER
3081: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3082:
3083:
3084: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE
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

Line 3085: ,p_oty_code OKL_CASH_FLOW_OBJECTS.OTY_CODE%TYPE

3081: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3082:
3083:
3084: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE
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

Line 3086: ,p_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE)

3082:
3083:
3084: CURSOR c_get_cashflow_info(p_src_id OKL_CASH_FLOW_OBJECTS.SOURCE_ID%TYPE
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

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;

Line 3095: lp_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE;

3091: AND CFO.OTY_CODE = p_oty_code
3092: AND CFO.SOURCE_TABLE=p_source_table
3093: AND CFLOW.CFO_ID = CFO.ID;
3094:
3095: lp_source_table OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE%TYPE;
3096: lv_stream_type_purpose VARCHAR2(150);
3097: i BINARY_INTEGER := 0;
3098: l_program_name CONSTANT VARCHAR2(30) := 'ppltu_cfl';
3099: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;