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 196: FROM dual;

192: -- else create one batch_id here. This is only for temp tables..so get it from massupdate seq.
193: -- ELSE
194: SELECT ego_massupdate_s.NEXTVAL
195: INTO p_batch_id
196: FROM dual;
197: END IF;
198: -- construct the search result query dynamically
199: -- dbms_output.put_line(' Called search_supplier_and_sites' );
200: 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 ';