APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT dependencies on OKL_CASH_FLOWS

Line 1574: FROM okl_cash_flows

1570:
1571: CURSOR c_cf_headers (p_cfo_id NUMBER)
1572: IS
1573: SELECT id, sty_id, due_arrears_yn, cft_code , sts_code
1574: FROM okl_cash_flows
1575: WHERE cfo_id = p_cfo_id;
1576: --Bug # 5021937 ssdeshpa start
1577: --changed the Cursor
1578: CURSOR c_cf_levels (p_caf_id NUMBER)

Line 1820: (SELECT id FROM okl_cash_flows WHERE cfo_id IN

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
1824: )

Line 1827: DELETE FROM okl_cash_flows WHERE cfo_id IN

1823: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id
1824: )
1825: );
1826:
1827: DELETE FROM okl_cash_flows WHERE cfo_id IN
1828: (SELECT id
1829: FROM okl_cash_flow_objects
1830: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id
1831: );

Line 1898: DELETE FROM okl_cash_flows WHERE id = p_cashflow_header_id;

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
1902:

Line 2040: FROM okl_cash_flows

2036: l_cdjv_tbl okl_cdj_pvt.cdjv_tbl_type;
2037:
2038: CURSOR csr_db_cashflows IS
2039: SELECT id
2040: FROM okl_cash_flows
2041: WHERE sts_code = 'WORK'
2042: AND DNZ_QTE_ID = p_quote_id;
2043:
2044: CURSOR csr_db_cashflow_levels IS

Line 2047: okl_cash_flows b

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

Line 2054: FROM okl_cash_flows

2050: AND B.DNZ_QTE_ID = p_quote_id;
2051:
2052: CURSOR csr_db_cashflow_objects IS
2053: SELECT cfo_id
2054: FROM okl_cash_flows
2055: WHERE sts_code = 'WORK'
2056: AND DNZ_QTE_ID = p_quote_id;
2057:
2058: CURSOR csr_sm_cashflow_levels IS

Line 2061: okl_cash_flows b,

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'
2065: AND B.DNZ_QTE_ID = p_quote_id

Line 2416: FROM okl_cash_flows

2412:
2413: CURSOR c_cf_headers (p_cfo_id NUMBER)
2414: IS
2415: SELECT id, sty_id, due_arrears_yn, cft_code
2416: FROM okl_cash_flows
2417: WHERE cfo_id = p_cfo_id;
2418:
2419: CURSOR c_cf_levels (p_caf_id NUMBER)
2420: IS