DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 1565: FROM okl_cash_flow_objects

1561: --Bug # 5021937 ssdeshpa end;
1562: CURSOR c_cf_objects (p_oty_code VARCHAR2, p_source_table VARCHAR2, p_source_id NUMBER)
1563: IS
1564: SELECT id
1565: FROM okl_cash_flow_objects
1566: WHERE
1567: oty_code = p_oty_code
1568: AND source_table = p_source_table
1569: AND source_id = p_source_id;

Line 1822: FROM okl_cash_flow_objects

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: )
1825: );
1826:

Line 1829: FROM okl_cash_flow_objects

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: );
1832:
1833: DELETE FROM okl_cash_flow_objects

Line 1833: DELETE FROM okl_cash_flow_objects

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: );
1832:
1833: DELETE 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:
1836: x_return_status := G_RET_STS_SUCCESS;
1837:

Line 2407: FROM okl_cash_flow_objects

2403:
2404: CURSOR c_cf_objects (p_oty_code VARCHAR2, p_source_table VARCHAR2, p_source_id NUMBER)
2405: IS
2406: SELECT id
2407: FROM okl_cash_flow_objects
2408: WHERE
2409: oty_code = p_oty_code
2410: AND source_table = p_source_table
2411: AND source_id = p_source_id;