APPS.PER_ES_ORG_INFO SQL Statements

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

Line: 21

    SELECT  business_group_id
    FROM    hr_all_organization_units
    WHERE   organization_id=p_organization_id;

Line: 26

    SELECT 'Y' FROM dual
    WHERE  EXISTS (SELECT /*+ ORDERED */ NULL from hr_lookups
                   WHERE LOOKUP_TYPE = 'ES_PROVINCE_CODES'
                   AND   LOOKUP_CODE = c_prov_code);

Line: 35

    SELECT 'Y'
    FROM   hr_organization_information hoi,hr_all_organization_units hou
    WHERE  hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
    AND    hou.organization_id = hoi.organization_id
    AND    org_information4 = c_org_info2
    AND    org_information1 <> c_org_info1
    AND    hou.business_group_id = c_business_group_id
    AND    c_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
    AND    EXISTS (SELECT 1 FROM hr_organization_information hoi1
                   WHERE hoi1.org_information1 = 'ES_WORK_CENTER'
                   AND   hoi1.org_information_context = 'CLASS'
                   AND   hoi1.organization_id = hoi.organization_id
                   AND   hoi1.org_information2 = 'Y');

Line: 201

PROCEDURE update_es_org_info(p_org_info_type_code   VARCHAR2
                            ,p_org_information1     VARCHAR2
                            ,p_org_information2     VARCHAR2
                            ,p_org_information3     VARCHAR2
                            ,p_org_information4     VARCHAR2
                            ,p_org_information5     VARCHAR2
                            ,p_org_information6     VARCHAR2
                            ,p_org_information7     VARCHAR2
                            ,p_org_information8     VARCHAR2
                            ,p_org_information_id   NUMBER
                            ,p_effective_date       DATE
                            ) IS
    --
    CURSOR get_business_group is
    SELECT business_group_id
    FROM   hr_all_organization_units   hou
          ,hr_organization_information hoi
    WHERE  hoi.org_information_id      = p_org_information_id
    AND    hoi.organization_id         = hou.organization_id;

Line: 222

    SELECT 'Y' FROM dual
    WHERE  EXISTS (SELECT /*+ ORDERED */ NULL from hr_lookups
                   WHERE LOOKUP_TYPE = 'ES_PROVINCE_CODES'
                   AND   LOOKUP_CODE = c_prov_code);

Line: 231

    SELECT 'Y'
    FROM   hr_organization_information hoi,hr_all_organization_units hou
    WHERE  hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
    AND    hou.organization_id = hoi.organization_id
    AND    org_information4 = c_org_info2
    AND    org_information1 <> c_org_info1
    AND    hou.business_group_id = c_business_group_id
    AND    c_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
    AND    EXISTS (SELECT 1 FROM hr_organization_information hoi1
                   WHERE hoi1.org_information1 = 'ES_WORK_CENTER'
                   AND   hoi1.org_information_context = 'CLASS'
                   AND   hoi1.organization_id = hoi.organization_id
                   AND   hoi1.org_information2 = 'Y');

Line: 396

END update_es_org_info;