APPS.PER_MX_DATA_PUMP SQL Statements

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

Line: 46

        SELECT hou.organization_id
          FROM hr_all_organization_units hou,
               hr_all_organization_units_tl houtl,
               hr_organization_information hoi,
               hr_organization_information hoi1
         WHERE hou.organization_id = hoi.organization_id(+)
           AND hou.organization_id = hoi1.organization_id
           AND hou.organization_id = houtl.organization_id
           AND hoi.org_information_context(+) = 'Employer Identification'
           AND hoi1.org_information_context = 'CLASS'
           AND hoi1.org_information1 = 'HR_LEGAL'
           AND hoi1.org_information2 = 'Y'
           AND houtl.language = userenv('LANG')
           AND hou.business_group_id = p_business_group_id
           AND hou.name = p_tax_unit;

Line: 93

        SELECT puc.user_column_id
          FROM pay_user_columns puc,
               pay_user_tables put
         WHERE puc.user_table_id = put.user_table_id
           AND puc.legislation_code = put.legislation_code
           AND puc.user_column_name = p_work_schedule
           AND put.user_table_name = 'COMPANY WORK SCHEDULES'
           AND put.legislation_code = 'MX'
           AND puc.business_group_id IS NULL;