APPS.JG_ZZ_SHARED_PKG SQL Statements

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

Line: 232

      SELECT
        DECODE(FPG.MULTI_ORG_FLAG, 'Y',
                DECODE(HOI2.ORG_INFORMATION_CONTEXT,
                       'Accounting Information',
                       TO_NUMBER(HOI2.ORG_INFORMATION3),
                       TO_NUMBER(NULL)
                      ),
              TO_NUMBER(NULL)
              )
      INTO l_org_id_from_inv
      FROM HR_ORGANIZATION_INFORMATION HOI1,
           HR_ORGANIZATION_INFORMATION HOI2,
           GL_SETS_OF_BOOKS GSOB,
           FND_PRODUCT_GROUPS FPG
      WHERE HOI1.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
        AND HOI1.ORG_INFORMATION1 = 'INV'
        AND HOI1.ORG_INFORMATION2 = 'Y'
        AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
        AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
        AND HOI2.ORG_INFORMATION1 = to_char(GSOB.set_of_books_id)
        AND HOI1.ORGANIZATION_ID = p_inv_org_id;

Line: 274

    l_Inv_Le_info_rec.delete;