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 1141: FROM okl_cash_flow_levels

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

Line 1584: FROM OKL_CASH_FLOW_LEVELS

1580: CURSOR c_cf_levels (p_caf_id NUMBER)
1581: IS
1582: SELECT amount, number_of_periods, fqy_code, stub_days, stub_amount, rate , missing_pmt_flag,
1583: start_date --05-Nov-2009 sechawla 9001346 : added
1584: FROM OKL_CASH_FLOW_LEVELS
1585: WHERE caf_id = p_caf_id
1586: order by start_date ;--05-Nov-2009 sechawla 9001346 : added
1587: --Bug # 5021937 ssdeshpa End
1588: BEGIN

Line 1830: DELETE FROM okl_cash_flow_levels WHERE caf_id IN

1826: ELSIF x_return_status = G_RET_STS_ERROR THEN
1827: RAISE OKL_API.G_EXCEPTION_ERROR;
1828: END IF;
1829:
1830: DELETE FROM okl_cash_flow_levels WHERE caf_id IN
1831: (SELECT id FROM okl_cash_flows WHERE cfo_id IN
1832: (SELECT id
1833: FROM okl_cash_flow_objects
1834: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id

Line 1908: DELETE FROM okl_cash_flow_levels WHERE caf_id = p_cashflow_header_id;

1904: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1905:
1906: BEGIN
1907:
1908: DELETE FROM okl_cash_flow_levels WHERE caf_id = p_cashflow_header_id;
1909: DELETE FROM okl_cash_flows WHERE id = p_cashflow_header_id;
1910:
1911: -- WIP
1912: -- EXISTENCE CHECK REQD FOR ADDl CF ON THE OBJECT

Line 1975: DELETE FROM okl_cash_flow_levels WHERE id = p_cashflow_level_id;

1971: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1972:
1973: BEGIN
1974:
1975: DELETE FROM okl_cash_flow_levels WHERE id = p_cashflow_level_id;
1976:
1977: x_return_status := G_RET_STS_SUCCESS;
1978:
1979: EXCEPTION

Line 2057: FROM okl_cash_flow_levels a,

2053: AND DNZ_QTE_ID = p_quote_id;
2054:
2055: CURSOR csr_db_cashflow_levels IS
2056: SELECT distinct a.id
2057: FROM okl_cash_flow_levels a,
2058: okl_cash_flows b
2059: WHERE a.caf_id = b.id
2060: AND b.sts_code = 'WORK'
2061: AND B.DNZ_QTE_ID = p_quote_id;

Line 2071: FROM okl_cash_flow_levels a,

2067: AND DNZ_QTE_ID = p_quote_id;
2068:
2069: CURSOR csr_sm_cashflow_levels IS
2070: SELECT distinct a.id, a.object_version_number
2071: FROM okl_cash_flow_levels a,
2072: okl_cash_flows b,
2073: okl_lease_quotes_b qte
2074: WHERE a.caf_id = b.id
2075: AND a.missing_pmt_flag = 'Y'

Line 2433: FROM OKL_CASH_FLOW_LEVELS

2429:
2430: CURSOR c_cf_levels (p_caf_id NUMBER)
2431: IS
2432: SELECT amount, number_of_periods, fqy_code, stub_days, stub_amount, rate
2433: FROM OKL_CASH_FLOW_LEVELS
2434: WHERE caf_id = p_caf_id;
2435:
2436: BEGIN
2437: