DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on DUAL

Line 221: FROM DUAL;

217: -- l_activity_product_id NUMBER;
218: -- Cursor to get the sequence for utilization_id
219: CURSOR c_utilization_seq IS
220: SELECT ozf_funds_utilized_s.NEXTVAL
221: FROM DUAL;
222:
223: -- Cursor to validate the uniqueness of the utilization_id
224: CURSOR c_utilization_count (cv_utilization_id IN NUMBER) IS
225: SELECT 'X'

Line 309: FROM DUAL

305: */
306:
307: CURSOR c_get_deal_accrual_flag(p_qp_list_header_id IN NUMBER, p_product_type IN VARCHAR2, p_product_id IN NUMBER) IS
308: SELECT 1
309: FROM DUAL
310: WHERE EXISTS (SELECT 1
311: FROM qp_list_lines line, qp_pricing_attributes attr
312: WHERE attr.list_header_id = p_qp_list_header_id
313: AND line.list_line_id = attr.list_line_id