DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 1567: FROM okl_cash_flow_objects

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

Line 1833: FROM okl_cash_flow_objects

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: )
1836: );
1837:

Line 1840: FROM okl_cash_flow_objects

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: );
1843:
1844: DELETE FROM okl_cash_flow_objects

Line 1844: DELETE FROM okl_cash_flow_objects

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: );
1843:
1844: DELETE FROM okl_cash_flow_objects
1845: WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id;
1846:
1847: x_return_status := G_RET_STS_SUCCESS;
1848:

Line 2418: FROM okl_cash_flow_objects

2414:
2415: CURSOR c_cf_objects (p_oty_code VARCHAR2, p_source_table VARCHAR2, p_source_id NUMBER)
2416: IS
2417: SELECT id
2418: FROM okl_cash_flow_objects
2419: WHERE
2420: oty_code = p_oty_code
2421: AND source_table = p_source_table
2422: AND source_id = p_source_id;