DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2892: FROM HR_ALL_ORGANIZATION_UNITS O,

2888: WHERE organization_id = p_cust_vr.org_id; */
2889: -- bug 5223014 sql id 17532992 (MJC) don't need 2nd HR_ORGANIZATION_INFORMATION O3 for identification
2890: -- (takes out MJC)
2891: SELECT 1
2892: FROM HR_ALL_ORGANIZATION_UNITS O,
2893: HR_ORGANIZATION_INFORMATION O2
2894: --HR_ORGANIZATION_INFORMATION O3
2895: WHERE o.organization_id = p_cust_vr.org_id
2896: and O2.ORGANIZATION_ID = o.organization_id