APPS.HR_BPL_ALERT_TRNSLT SQL Statements

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

Line: 31

    SELECT   flv.meaning
    FROM     fnd_lookup_values flv
    WHERE    flv.lookup_code = c_lookup_code
    AND      flv.lookup_type = c_lookup_type
    AND      flv.language = c_language
    AND      flv.view_application_id = 3
    AND      flv.security_group_id = 0;

Line: 52

  SELECT org1.name
        ,org1.language
  FROM hr_all_organization_units_tl org1
  WHERE org1.organization_id = cp_organization_id
  AND   ((org1.language = cp_language) OR
         ((NOT EXISTS (SELECT 'x'
                       FROM hr_all_organization_units_tl org2
                       WHERE org1.organization_id = org2.organization_id
                       AND org2.language = cp_language)) AND
          (org1.language = org1.source_lang)));

Line: 124

  SELECT loc1.location_code
        ,loc1.language
  FROM hr_locations_all_tl loc1
  WHERE loc1.location_id = cp_location_id
  AND   ((loc1.language = cp_language) OR
         ((NOT EXISTS (SELECT 'x'
                       FROM hr_locations_all_tl loc2
                       WHERE loc1.location_id = loc2.location_id
                       AND language = cp_language)) AND
          (loc1.language = loc1.source_lang)));

Line: 195

  SELECT job.job_id
        ,job.name
  FROM per_jobs job
  WHERE job.job_id = cp_job_id;

Line: 262

  SELECT pos.position_id
        ,pos.name
  FROM per_positions pos
  WHERE pos.position_id = cp_position_id;

Line: 324

  SELECT grd.grade_id
        ,grd.name
  FROM per_grades   grd
  WHERE grd.grade_id = cp_grade_id;