DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2743: FROM HR_ALL_ORGANIZATION_UNITS O,

2739: WHERE organization_id = p_cust_vr.org_id; */
2740: -- bug 5223014 sql id 17532992 (MJC) don't need 2nd HR_ORGANIZATION_INFORMATION O3 for identification
2741: -- (takes out MJC)
2742: SELECT 1
2743: FROM HR_ALL_ORGANIZATION_UNITS O,
2744: HR_ORGANIZATION_INFORMATION O2
2745: --HR_ORGANIZATION_INFORMATION O3
2746: WHERE o.organization_id = p_cust_vr.org_id
2747: and O2.ORGANIZATION_ID = o.organization_id