APPS.HR_WPM_NTF_UTIL SQL Statements

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

Line: 15

         SELECT wf.NAME role_name
           FROM wf_roles wf
          WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;

Line: 21

         SELECT NVL (GLOBAL_NAME, first_name || ', ' || last_name)
           FROM per_all_people_f
          WHERE person_id = p_person_id
            AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Line: 28

         SELECT *
           FROM per_personal_scorecards
          WHERE scorecard_id = p_scorecard_id;

Line: 34

         SELECT paf.supervisor_id
           FROM per_all_assignments_f paf, per_personal_scorecards sc
          WHERE sc.scorecard_id = p_sc_id
            AND sc.assignment_id = paf.assignment_id
            AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
            AND paf.assignment_type IN ('E', 'C');

Line: 43

         SELECT person_id
           FROM per_personal_scorecards
          WHERE scorecard_id = p_scorecard_id;

Line: 49

         SELECT PLAN.hierarchy_type_code, PLAN.supervisor_id, PLAN.supervisor_assignment_id
           FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN
          WHERE sc.scorecard_id = p_sc_id AND sc.plan_id = PLAN.plan_id;

Line: 55

         SELECT sup.person_id
           FROM per_personal_scorecards sc,
                per_all_assignments_f wrk,
                per_pos_structure_elements ppse,
                per_all_assignments_f sup,
                per_perf_mgmt_plans plans
          WHERE sc.scorecard_id = p_sc_id
            AND plans.plan_id = sc.plan_id
            AND sc.assignment_id = wrk.assignment_id
            AND TRUNC (SYSDATE) BETWEEN wrk.effective_start_date AND wrk.effective_end_date
            AND wrk.position_id = ppse.subordinate_position_id
            AND ppse.pos_structure_version_id = plans.pos_structure_version_id
            AND ppse.business_group_id = sup.business_group_id
            AND ppse.parent_position_id = sup.position_id
            AND TRUNC (SYSDATE) BETWEEN sup.effective_start_date AND sup.effective_end_date
	    AND ( ( plans.assignment_types_code IN ('E', 'C')
                    AND sup.assignment_type = plans.assignment_types_code
                   )
                 OR ( plans.assignment_types_code = 'EC' AND sup.assignment_type IN ('E', 'C')
                   ) )
            AND EXISTS (
                   SELECT 'x'
                     FROM per_person_type_usages_f ptu, per_person_types ppt
                    WHERE ptu.person_id = sup.person_id
                      AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
                      AND ptu.person_type_id = ppt.person_type_id
                      AND ppt.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'CWK_APL'));

Line: 132

          UPDATE per_personal_scorecards
               SET status_code = 'PUBLISHED'
             WHERE scorecard_id = score_card_id;

Line: 341

            UPDATE per_personal_scorecards
               SET status_code = 'APPROVAL'
             WHERE scorecard_id = score_card_id;