APPS.CN_PAY_ELEMENT_INPUTS_PVT dependencies on DUAL

Line 177: SELECT 1 INTO l_dummy FROM dual

173: p_column_name = 'PAYMENT_AMOUNT' THEN
174:
175: -- Check for duplicate
176: BEGIN
177: SELECT 1 INTO l_dummy FROM dual
178: WHERE NOT EXISTS
179: ( SELECT 1
180: FROM cn_pay_element_inputs
181: WHERE tab_object_id = p_pay_element_input_rec.tab_object_id

Line 328: FROM dual;

324: l_pay_element_input_rec.line_number,
325: l_pay_element_input_rec.element_input_id,
326: l_pay_element_input_rec.table_name,
327: l_pay_element_input_rec.column_name
328: FROM dual;
329:
330: -- get table
331:
332: get_object_id(l_pay_element_input_rec.table_name,

Line 545: FROM dual;

541: l_pay_element_input_rec.col_object_id,
542: l_pay_element_input_rec.start_date,
543: l_pay_element_input_rec.end_date,
544: l_pay_element_input_rec.quota_pay_element_id
545: FROM dual;
546:
547:
548: get_object_id(l_pay_element_input_rec.table_name,
549: 'TBL',