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')));
35: EXCEPTION
36:
37: WHEN OTHERS THEN
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')));
35: EXCEPTION
36:
37: WHEN OTHERS THEN
38: raise;