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 229: Select p_customer_id from dual

225: WHERE address_id = p_address_id
226: AND status = 'A' --12645675 - Condition to check if the Site Usage is Active
227: AND
228: customer_id in (
229: Select p_customer_id from dual
230: union
231: select cust_account_id from
232: hz_cust_acct_relate_all where
233: related_cust_account_id = p_customer_id)

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

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

Line 426: FROM DUAL;

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