APPS.OKC_CONTEXT SQL Statements

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

Line: 20

    SELECT business_group_id
    FROM   HR_ALL_ORGANIZATION_UNITS OU,
           HR_ORGANIZATION_INFORMATION OI1,
           HR_ORGANIZATION_INFORMATION OI2
    WHERE  OU.ORGANIZATION_ID = p_id
      AND  OI1.ORG_INFORMATION1 = 'OPERATING_UNIT'
      AND  OI2.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
      AND  OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID
      AND OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID;

Line: 32

    SELECT business_group_id
    FROM   okx_organization_defs_v
    WHERE  id1= p_id
    AND    ORGANIZATION_TYPE = 'OPERATING_UNIT' AND INFORMATION_TYPE = 'Operating Unit Information';

Line: 109

    SELECT authoring_org_id,
           inv_organization_id
    FROM   okc_k_headers_all_b --changed to _all for MOAC
    WHERE  id = p_chr_id;

Line: 117

    SELECT business_group_id
    FROM   HR_ALL_ORGANIZATION_UNITS OU
    WHERE  OU.ORGANIZATION_ID = p_id;

Line: 123

    SELECT business_group_id
    FROM   okx_organization_defs_v
    WHERE  id1= p_id
    AND    ORGANIZATION_TYPE = 'OPERATING_UNIT' AND INFORMATION_TYPE = 'Operating Unit Information';