DBA Data[Home] [Help]

APPS.JTF_IH_CORE_UTIL_PVT dependencies on DUAL

Line 244: FROM dual;

240: IF p_org_id = fnd_api.g_miss_num THEN
241: SELECT To_number(Decode(substrb(userenv('CLIENT_INFO'),1,1), ' ',
242: NULL, substrb(userenv('CLIENT_INFO'),1,10)))
243: INTO p_org_id
244: FROM dual;
245: IF p_org_id IS NULL THEN
246: p_org_id := To_number(fnd_profile.value_specific('ORG_ID',
247: p_user_id,
248: p_resp_id,