APPS.PA_JOB_UTILS SQL Statements

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

Line: 22

       pa_debug.write('log_message: ' || 'HR_UPDATE_API', 'log: ' || p_log_msg, 3);

Line: 51

			 SELECT job_id
			 INTO   x_job_id
		         FROM   per_jobs
		         WHERE  job_id = p_job_id
                         AND job_group_id = nvl(p_job_group_id, job_group_id) -- 5130421
                         ;

Line: 61

	        SELECT job_id
	        INTO   x_job_id
	        FROM   per_jobs
	        WHERE  name = p_job_name
                AND job_group_id = nvl(p_job_group_id, job_group_id) -- 5130421
                ;

Line: 108

            select job_level
            from PA_SETUP_JOB_LEVELS_V
            where job_level = p_level;

Line: 165

          SELECT job_group_id
          FROM per_job_groups
          WHERE displayed_name = p_job_group_name;

Line: 172

			SELECT job_group_id
		        INTO   x_job_group_id
		        FROM   per_job_groups
		        WHERE  job_group_id = p_job_group_id;

Line: 211

		SELECT job_group_id
	        INTO   x_job_group_id
	        FROM   per_job_groups
	        WHERE  displayed_name = p_job_group_name;

Line: 263

        SELECT job_group_id
        INTO   v_job_group_id
        FROM   per_jobs
        WHERE  job_id = p_job_id
         AND   job_group_id = p_job_group_id;

Line: 330

        SELECT BUSINESS_GROUP_ID
        INTO l_business_group_id
        FROM PER_JOBS
        WHERE job_id = p_job_id;

Line: 339

     SELECT ORG_INFORMATION1
     INTO l_prjg_id
     FROM HR_ORGANIZATION_INFORMATION
     WHERE ORGANIZATION_ID=l_business_group_id
     AND ORG_INFORMATION_CONTEXT='Project Resource Job Group';

Line: 405

           SELECT to_job_id,to_job_group_id
           FROM pa_job_relationships, per_job_groups pjg
           WHERE from_job_id = P_job_id
           AND from_job_group_id = P_job_group_id
           AND to_job_group_id = pjg.job_group_id
           AND pjg.master_flag = 'Y';

Line: 413

           SELECT from_job_id,from_job_group_id
           FROM pa_job_relationships, per_job_groups pjg
           WHERE to_job_id = P_job_id
           AND to_job_group_id = P_job_group_id
           AND from_job_group_id = pjg.job_group_id
           AND pjg.master_flag = 'Y';

Line: 421

           SELECT to_job_id
           FROM pa_job_relationships
           WHERE from_job_id = l_master_job_id
           AND from_job_group_id = l_master_job_group_id
           AND to_job_group_id = l_prjg_id;

Line: 428

           SELECT from_job_id
           FROM pa_job_relationships
           WHERE to_job_id = l_master_job_id
           AND to_job_group_id = l_master_job_group_id
           AND from_job_group_id = l_prjg_id;

Line: 507

  SELECT jei_information4
  INTO l_job_level
  FROM per_job_extra_info
  WHERE job_id = p_job_id
  AND information_type = 'Job Category'
  AND jei_information4 IS NOT NULL; -- Bug 2898766

Line: 611

        SELECT master_flag
        INTO   v_master_flag
        FROM   per_job_groups
        WHERE  job_group_id = v_job_group_id;

Line: 638

        SELECT job_group_id
        INTO   v_job_grp_id
        FROM   per_jobs
        WHERE  job_id = P_job_id;

Line: 679

           RETURN PA_HR_UPDATE_API.Get_Job_Name (p_job_id => p_job_id);

Line: 691

           RETURN PA_HR_UPDATE_API.Get_Job_Name(p_job_id => l_mapped_job_id);

Line: 707

         Cursor C1 IS Select * from PA_JOB_RELATIONSHIPS where
                FROM_JOB_ID = p_job_id OR TO_JOB_ID = p_job_id;

Line: 718

               ,msg => 'Relations involving this job exist in Projects. Please delete those relations before deleting the job!');