APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT dependencies on OKL_CASH_FLOWS

Line 1576: FROM okl_cash_flows

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

Line 1831: (SELECT id FROM okl_cash_flows WHERE cfo_id IN

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

Line 1838: DELETE FROM okl_cash_flows WHERE cfo_id IN

1834: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id
1835: )
1836: );
1837:
1838: DELETE FROM okl_cash_flows WHERE cfo_id IN
1839: (SELECT id
1840: FROM okl_cash_flow_objects
1841: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id
1842: );

Line 1909: DELETE FROM okl_cash_flows WHERE id = p_cashflow_header_id;

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

Line 2051: FROM okl_cash_flows

2047: l_cdjv_tbl okl_cdj_pvt.cdjv_tbl_type;
2048:
2049: CURSOR csr_db_cashflows IS
2050: SELECT id
2051: FROM okl_cash_flows
2052: WHERE sts_code = 'WORK'
2053: AND DNZ_QTE_ID = p_quote_id;
2054:
2055: CURSOR csr_db_cashflow_levels IS

Line 2058: okl_cash_flows b

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

Line 2065: FROM okl_cash_flows

2061: AND B.DNZ_QTE_ID = p_quote_id;
2062:
2063: CURSOR csr_db_cashflow_objects IS
2064: SELECT cfo_id
2065: FROM okl_cash_flows
2066: WHERE sts_code = 'WORK'
2067: AND DNZ_QTE_ID = p_quote_id;
2068:
2069: CURSOR csr_sm_cashflow_levels IS

Line 2072: okl_cash_flows b,

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

Line 2427: FROM okl_cash_flows

2423:
2424: CURSOR c_cf_headers (p_cfo_id NUMBER)
2425: IS
2426: SELECT id, sty_id, due_arrears_yn, cft_code
2427: FROM okl_cash_flows
2428: WHERE cfo_id = p_cfo_id;
2429:
2430: CURSOR c_cf_levels (p_caf_id NUMBER)
2431: IS