eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PMP_MASS_NOTIFICATION SQL Statements

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

Line: 25


   SELECT   ppf.person_id,
            usr.name user_name,
            ppf.full_name
    FROM    per_people_f ppf
           ,wf_roles usr
    WHERE   ppf.person_id = p_person_id
    AND     p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
    AND     ppf.person_id = usr.orig_system_id(+)
    AND     usr.orig_system(+) = 'PER';

Line: 39


    SELECT  distinct ppf.person_id,
            usr.name   user_name,
            ppf.full_name
    FROM    per_personal_scorecards sc
           ,per_assignments_f paf
           ,per_people_f ppf
           ,wf_roles usr
    WHERE   sc.plan_id = p_plan_id
    AND     p_effective_date BETWEEN sc.start_date AND sc.end_date
    AND     sc.assignment_id = paf.assignment_id
    AND     p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
    AND     paf.person_id = ppf.person_id
    AND     p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
    AND     ppf.person_id = usr.orig_system_id(+)
    AND     usr.orig_system(+) = 'PER';

Line: 58


    SELECT  DISTINCT  ppf.person_id,
            usr.name    user_name,
            ppf.full_name
    FROM    per_personal_scorecards sc
           ,per_assignments_f paf
           ,per_people_f ppf
           ,wf_roles usr
    WHERE   sc.plan_id = p_plan_id
    AND     p_effective_date BETWEEN sc.start_date AND sc.end_date
    AND     sc.assignment_id = paf.assignment_id
    AND     p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
    AND     paf.supervisor_id = ppf.person_id
    AND     p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
    AND     paf.supervisor_id = usr.orig_system_id(+)
    AND     usr.orig_system(+) = 'PER';

Line: 79


    SELECT distinct ppf.person_id
          ,usr.name user_name
          ,ppf.full_name
    FROM  per_personal_scorecards sc
         ,per_assignments_f paf
         ,per_people_f ppf
         ,wf_roles usr
    WHERE sc.plan_id = p_plan_id
    AND   p_effective_date BETWEEN sc.start_date AND sc.end_date
    AND   sc.status_code = p_status
    AND   sc.assignment_id = paf.assignment_id
    AND   p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
    AND   paf.supervisor_id = ppf.person_id
    AND   p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
    AND   paf.supervisor_id = usr.orig_system_id(+)
    AND   usr.orig_system(+) = 'PER';

Line: 101


    SELECT distinct ppf.person_id
          ,usr.name user_name
          ,ppf.full_name
    FROM  per_personal_scorecards sc
         ,per_assignments_f paf
         ,per_people_f ppf
         ,wf_roles usr
    WHERE sc.plan_id = p_plan_id
    AND   p_effective_date BETWEEN sc.start_date AND sc.end_date
    AND   sc.status_code = p_status
    AND   sc.assignment_id = paf.assignment_id
    AND   p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
    AND   paf.person_id = ppf.person_id
    AND   p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
    AND   paf.person_id = usr.orig_system_id(+)
    AND   usr.orig_system(+) = 'PER';

Line: 121


   SELECT DISTINCT ppf.person_id
         ,usr.name user_name
         ,ppf.full_name
   FROM   per_assignments_f paf
         ,per_personal_scorecards sc
         ,per_people_f ppf
         ,wf_roles usr
   WHERE sc.plan_id = p_plan_id
   AND   p_effective_date BETWEEN sc.start_date AND sc.end_date
   AND   sc.status_code <> 'PUBLISHED'
   AND   sc.assignment_id = paf.assignment_id
   AND   p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND   paf.person_id = ppf.person_id
   AND   p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
   AND   paf.person_id = usr.orig_system_id(+)
   AND   usr.orig_system(+) = 'PER';

Line: 141


   SELECT DISTINCT ppf.person_id
         ,usr.name user_name
         ,ppf.full_name
   FROM   per_assignments_f paf
         ,per_personal_scorecards sc
         ,per_people_f ppf
         ,wf_roles usr
   WHERE sc.plan_id = p_plan_id
   AND   p_effective_date BETWEEN sc.start_date AND sc.end_date
   AND   sc.status_code <> 'PUBLISHED'
   AND   sc.assignment_id = paf.assignment_id
   AND   p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND   paf.supervisor_id = ppf.person_id
   AND   p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
   AND   paf.supervisor_id = usr.orig_system_id(+)
   AND   usr.orig_system(+) = 'PER';

Line: 161


   SELECT DISTINCT paf.person_id
         ,usr.name user_name
         ,ppf.full_name
   FROM   per_assignments_f paf
         ,per_appraisals apr
         ,per_people_f ppf
         ,wf_roles usr
   WHERE apr.plan_id = p_plan_id
   AND   apr.appraisal_system_status = p_status_code
   AND   apr.appraisee_person_id = paf.person_id
   AND   p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND   paf.person_id = ppf.person_id
   AND   p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
   AND   paf.person_id = usr.orig_system_id(+)
   AND   usr.orig_system(+) = 'PER';

Line: 180


   SELECT DISTINCT ppf.person_id
         ,usr.name user_name
         ,ppf.full_name
   FROM   per_assignments_f paf
         ,per_appraisals apr
         ,per_people_f ppf
         ,wf_roles usr
   WHERE apr.plan_id = p_plan_id
   AND   apr.appraisal_system_status = p_status_code
   AND   apr.main_appraiser_id = paf.person_id
   AND   p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND   paf.person_id = ppf.person_id
   AND   p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
   AND   paf.person_id = usr.orig_system_id(+)
   AND   usr.orig_system(+) = 'PER';

Line: 300


     select name from wf_roles
     where orig_system_id  = p_person_id
     and orig_system = 'PER';

Line: 304


  SELECT a.application_short_name
  FROM  fnd_new_messages m
       ,fnd_application a
  WHERE m.message_name = p_message_name
  AND   m.language_code = USERENV('LANG')
  AND   m.application_id = a.application_id;

Line: 315


  SELECT ADMINISTRATOR_PERSON_ID INTO  l_admin_person_id FROM per_perf_mgmt_plans WHERE plan_id =p_plan_id;

Line: 337


    SELECT HR_workflow_item_key_s.NEXTVAL
    INTO item_key
    FROM dual;

Line: 380


                     ,p_person_selection_rule  IN NUMBER DEFAULT NULL) IS
 l_effective_date DATE;

Line: 406


 IF p_target_population IS NULL AND p_target_person_id IS NULL AND p_person_selection_rule IS NULL THEN
   fnd_message.set_name('PER','PER_NO_POPULATION_TO_NOTIFY');

Line: 421


 g_userdtls.DELETE;