APPS.PA_SEARCH_PUB SQL Statements

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

Line: 84

  SELECT asgn.min_resource_job_level,
         asgn.max_resource_job_level,
         asgn.start_date,
         asgn.end_date,
         asgn.competence_match_weighting,
         asgn.availability_match_weighting,
         asgn.job_level_match_weighting,
         asgn.search_min_availability,
         asgn.search_country_code,
         asgn.SEARCH_EXP_ORG_STRUCT_VER_ID,
         asgn.SEARCH_EXP_START_ORG_ID
  FROM   pa_project_assignments asgn
  WHERE  asgn.assignment_id = p_assignment_id;

Line: 100

  SELECT step_value
  FROM   per_rating_levels
  WHERE  rating_level_id = l_rating_level_id;

Line: 799

     PA_SEARCH_GLOB.g_competence_criteria.DELETE;

Line: 829

     PA_SEARCH_GLOB.g_competence_criteria.DELETE;

Line: 838

       PA_SEARCH_GLOB.g_competence_criteria.DELETE;