APPS.PA_ROLE_PROFILES_UTILS SQL Statements

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

Line: 25

      SELECT business_group_id
      FROM per_business_groups
      WHERE name = p_business_group_name;

Line: 57

        SELECT business_group_id
        INTO x_business_group_id
        FROM per_business_groups
        WHERE name = p_business_group_name;

Line: 114

      SELECT position_id
      FROM per_positions
      WHERE name = p_position_name;

Line: 146

        SELECT position_id
        INTO x_position_id
        FROM per_positions
        WHERE name = p_position_name;

Line: 293

        SELECT 'Y'
        INTO l_exists
        FROM HR_ORGANIZATION_UNITS
        WHERE organization_id = x_organization_id
        AND   business_group_id = NVL(x_business_group_id, business_group_id);

Line: 308

        SELECT 'Y'
        INTO l_exists
        FROM PER_JOBS
        WHERE job_id = x_job_id
        AND   business_group_id = NVL(x_business_group_id, business_group_id);

Line: 323

        SELECT 'Y'
        INTO l_exists
        FROM PER_POSITIONS
        WHERE business_group_id = NVL(x_business_group_id, business_group_id)
        AND   organization_id = NVL(x_organization_id, organization_id)
        AND   job_id = NVL(x_job_id, job_id)
        AND   position_id = x_position_id;