APPS.JG_ZZ_COMPANY_INFO dependencies on HR_ORGANIZATION_UNITS

Line 30: FROM hr_organization_units org,

26:
27: BEGIN
28: SELECT org.location_id
29: INTO location_id
30: FROM hr_organization_units org,
31: fnd_product_groups prod
32: WHERE org.organization_id = to_number(decode(nvl(prod.multi_org_flag,'N'), 'Y',
33: fnd_profile.value_wnps('ORG_ID'),
34: fnd_profile.value_wnps('JGZZ_COMP_ID')));