APPS.ECEPOI dependencies on DUAL

Line 184: Select p_customer_id from dual

180: From oe_ship_to_orgs_v
181: WHERE address_id = p_address_id
182: AND status = 'A' AND
183: customer_id in (
184: Select p_customer_id from dual
185: union
186: select cust_account_id from
187: hz_cust_acct_relate_all where
188: related_cust_account_id = p_customer_id)

Line 227: Select p_customer_id from dual

223: From oe_invoice_to_orgs_v
224: WHERE address_id = p_address_id
225: AND
226: customer_id in (
227: Select p_customer_id from dual
228: union
229: select cust_account_id from
230: hz_cust_acct_relate_all where
231: related_cust_account_id = p_customer_id)

Line 347: EXECUTE IMMEDIATE 'Begin SELECT OE_XML_MESSAGE_SEQ_S.nextval INTO :1 FROM DUAL; end;'

343: return;
344: END IF;
345: END IF;
346:
347: EXECUTE IMMEDIATE 'Begin SELECT OE_XML_MESSAGE_SEQ_S.nextval INTO :1 FROM DUAL; end;'
348: USING out l_eventkey;
349:
350: IF p_status IS NULL THEN
351: IF l_transaction_type IN ('855', '865') THEN

Line 424: FROM DUAL;

420: IF l_org_id IS NULL THEN
421: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
422: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
423: INTO l_org_id
424: FROM DUAL;
425: END IF;
426:
427: wf_event.AddParameterToList(p_name=> 'ORG_ID',
428: p_value=> l_org_id,