DBA Data[Home] [Help]

APPS.PN_PROFILE_UPGRADE dependencies on DUAL

Line 281: FROM dual

277: UNION
278: SELECT TO_CHAR(g_default_org_id) org_id,
279: 0 resp_id,
280: 0 num_users
281: FROM dual
282: WHERE NOT EXISTS (SELECT NULL
283: FROM fnd_profile_option_values v
284: WHERE v.profile_option_id = g_profileid4orgid
285: AND v.profile_option_value = g_default_org_id

Line 544: FROM dual

540: UNION
541: SELECT TO_CHAR(g_default_org_id) org_id,
542: 0 resp_id,
543: 0 num_users
544: FROM dual
545: WHERE NOT EXISTS (SELECT NULL
546: FROM fnd_profile_option_values v
547: WHERE v.profile_option_id = g_profileid4orgid
548: AND v.profile_option_value = g_default_org_id