DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on DUAL

Line 138: FROM DUAL;

134: -- l_activity_product_id NUMBER;
135: -- Cursor to get the sequence for utilization_id
136: CURSOR c_utilization_seq IS
137: SELECT ozf_funds_utilized_s.NEXTVAL
138: FROM DUAL;
139:
140: -- Cursor to validate the uniqueness of the utilization_id
141: CURSOR c_utilization_count (cv_utilization_id IN NUMBER) IS
142: SELECT 'X'

Line 204: FROM DUAL

200: */
201:
202: CURSOR c_get_deal_accrual_flag(p_qp_list_header_id IN NUMBER, p_product_type IN VARCHAR2, p_product_id IN NUMBER) IS
203: SELECT 1
204: FROM DUAL
205: WHERE EXISTS (SELECT 1
206: FROM qp_list_lines line, qp_pricing_attributes attr
207: WHERE attr.list_header_id = p_qp_list_header_id
208: AND line.list_line_id = attr.list_line_id