APPS.CS_CORE_UTIL dependencies on DUAL

Line 425: FROM dual;

421: IF p_org_id = fnd_api.g_miss_num THEN
422: SELECT To_number(Decode(substrb(userenv('CLIENT_INFO'),1,1), ' ',
423: NULL, substrb(userenv('CLIENT_INFO'),1,10)))
424: INTO p_org_id
425: FROM dual;
426: IF p_org_id IS NULL THEN
427: p_org_id := To_number(fnd_profile.value_specific('ORG_ID',
428: p_user_id,
429: p_resp_id,

Line 614: FROM dual

610: WHERE contact_id = p_customer_contact_id
611: AND status = 'A'
612: AND customer_id IN
613: ( SELECT p_customer_id
614: FROM dual
615: UNION
616: SELECT related_customer_id
617: FROM ra_customer_relationships_all
618: WHERE customer_id = p_customer_id

Line 1053: FROM dual;

1049: -- Store the old value of the multi-org context
1050: SELECT To_number(Decode(substrb(userenv('CLIENT_INFO'),1,1), ' ', NULL,
1051: substrb(userenv('CLIENT_INFO'),1,10)))
1052: INTO l_orig_org_id
1053: FROM dual;
1054:
1055: IF (p_org_id IS NOT NULL) THEN
1056: -- Set the multi-org context using p_org_id
1057: fnd_client_info.set_org_context(p_org_id);

Line 1231: FROM dual

1227: AND a.address_id = su.address_id
1228: AND Nvl(a.org_id,-99) = Decode(a.org_id,NULL,-99,p_org_id)
1229: AND a.customer_id IN
1230: ( SELECT p_customer_id
1231: FROM dual
1232: UNION
1233: SELECT related_customer_id
1234: FROM ra_customer_relationships_all
1235: WHERE customer_id = p_customer_id