DBA Data[Home] [Help]

APPS.JG_ZZ_COMPANY_INFO dependencies on FND_PROFILE

Line 33: fnd_profile.value_wnps('ORG_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')));
35: EXCEPTION
36:
37: WHEN OTHERS THEN

Line 34: fnd_profile.value_wnps('JGZZ_COMP_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
38: raise;