APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 18: FROM okl_cash_flow_levels

14: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
15:
16: CURSOR c_levels IS
17: SELECT id
18: FROM okl_cash_flow_levels
19: WHERE caf_id = p_cf_header_id
20: ORDER BY start_date;
21:
22: i BINARY_INTEGER;

Line 1139: FROM okl_cash_flow_levels

1135: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1136:
1137: CURSOR c_db_cashflow_levels IS
1138: SELECT id
1139: FROM okl_cash_flow_levels
1140: WHERE caf_id = p_cashflow_header_id;
1141:
1142: l_cashflow_level_tbl cflv_tbl_type;
1143: l_delete_flag VARCHAR2(1);

Line 1581: FROM OKL_CASH_FLOW_LEVELS

1577: --changed the Cursor
1578: CURSOR c_cf_levels (p_caf_id NUMBER)
1579: IS
1580: SELECT amount, number_of_periods, fqy_code, stub_days, stub_amount, rate , missing_pmt_flag
1581: FROM OKL_CASH_FLOW_LEVELS
1582: WHERE caf_id = p_caf_id;
1583: --Bug # 5021937 ssdeshpa End
1584: BEGIN
1585:

Line 1819: DELETE FROM okl_cash_flow_levels WHERE caf_id IN

1815: ELSIF x_return_status = G_RET_STS_ERROR THEN
1816: RAISE OKL_API.G_EXCEPTION_ERROR;
1817: END IF;
1818:
1819: DELETE FROM okl_cash_flow_levels WHERE caf_id IN
1820: (SELECT id FROM okl_cash_flows WHERE cfo_id IN
1821: (SELECT id
1822: FROM okl_cash_flow_objects
1823: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id

Line 1897: DELETE FROM okl_cash_flow_levels WHERE caf_id = p_cashflow_header_id;

1893: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1894:
1895: BEGIN
1896:
1897: DELETE FROM okl_cash_flow_levels WHERE caf_id = p_cashflow_header_id;
1898: DELETE FROM okl_cash_flows WHERE id = p_cashflow_header_id;
1899:
1900: -- WIP
1901: -- EXISTENCE CHECK REQD FOR ADDl CF ON THE OBJECT

Line 1964: DELETE FROM okl_cash_flow_levels WHERE id = p_cashflow_level_id;

1960: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1961:
1962: BEGIN
1963:
1964: DELETE FROM okl_cash_flow_levels WHERE id = p_cashflow_level_id;
1965:
1966: x_return_status := G_RET_STS_SUCCESS;
1967:
1968: EXCEPTION

Line 2046: FROM okl_cash_flow_levels a,

2042: AND DNZ_QTE_ID = p_quote_id;
2043:
2044: CURSOR csr_db_cashflow_levels IS
2045: SELECT distinct a.id
2046: FROM okl_cash_flow_levels a,
2047: okl_cash_flows b
2048: WHERE a.caf_id = b.id
2049: AND b.sts_code = 'WORK'
2050: AND B.DNZ_QTE_ID = p_quote_id;

Line 2060: FROM okl_cash_flow_levels a,

2056: AND DNZ_QTE_ID = p_quote_id;
2057:
2058: CURSOR csr_sm_cashflow_levels IS
2059: SELECT distinct a.id, a.object_version_number
2060: FROM okl_cash_flow_levels a,
2061: okl_cash_flows b,
2062: okl_lease_quotes_b qte
2063: WHERE a.caf_id = b.id
2064: AND a.missing_pmt_flag = 'Y'

Line 2422: FROM OKL_CASH_FLOW_LEVELS

2418:
2419: CURSOR c_cf_levels (p_caf_id NUMBER)
2420: IS
2421: SELECT amount, number_of_periods, fqy_code, stub_days, stub_amount, rate
2422: FROM OKL_CASH_FLOW_LEVELS
2423: WHERE caf_id = p_caf_id;
2424:
2425: BEGIN
2426: