APPS.JG_ZZ_COMPANY_INFO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

    SELECT org.location_id
    INTO   location_id
    FROM   hr_organization_units org,
           fnd_product_groups prod
    WHERE  org.organization_id = to_number(decode(nvl(prod.multi_org_flag,'N'), 'Y',
                                           fnd_profile.value_wnps('ORG_ID'),
                                           fnd_profile.value_wnps('JGZZ_COMP_ID')));