APPS.PA_JOB SQL Statements

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

Line: 112

  job_delete_allowed  VARCHAR2(1);

Line: 115

    select 'X'
    into   job_delete_allowed
    from   sys.dual
    where not exists (
     select null
     from  pa_implementations_all imp,
	   per_jobs job
     where job.job_id = p_job_id
     and   job.business_group_id = imp.business_group_id );

Line: 140

      SELECT 'The Job may not be deleted if PA is installed and implemented'
      FROM   fnd_product_installations fpi
      ,      pa_implementations_all imp
      WHERE  fpi.application_id = 275
      AND    fpi.status         = 'I';

Line: 153

       hr_utility.set_message (275,'PA_JOB_CANT_DELETE');