APPS.EGO_ITEM_ASSOCIATIONS_UTIL dependencies on DUAL

Line 73: FROM dual

69: l_vendor_contact VARCHAR2(1) := 'F';
70: BEGIN
71: SELECT 'T'
72: INTO l_vendor_contact
73: FROM dual
74: WHERE EXISTS
75: (
76: SELECT 1
77: FROM ap_supplier_contacts ascs

Line 197: FROM dual;

193: -- else create one batch_id here. This is only for temp tables..so get it from massupdate seq.
194: -- ELSE
195: SELECT ego_massupdate_s.NEXTVAL
196: INTO p_batch_id
197: FROM dual;
198: END IF;
199: -- construct the search result query dynamically
200: -- dbms_output.put_line(' Called search_supplier_and_sites' );
201: l_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ';