APPS.HRI_BPL_PERF_RATING SQL Statements

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

Line: 127

    SELECT formula_id
    FROM   ff_formulas_f
    WHERE  business_group_id = p_business_group_id
    AND    p_date BETWEEN effective_start_date
                  AND     effective_end_date
    AND    formula_name = p_ff_name;

Line: 612

    SELECT column_name
    INTO   l_column
    FROM  sys.all_tab_columns
    WHERE table_name = 'PER_APPRAISALS'
    AND   column_name = 'ASSIGNMENT_ID'
    AND   owner = l_schema;

Line: 623

  l_perf_select_sql VARCHAR2(1500);

Line: 631

  l_appr_select_sql VARCHAR2(1000);

Line: 641

  l_outer_select          VARCHAR2(1000);

Line: 670

  l_perf_select_sql :=
    'SELECT perf.performance_rating    perf_rating,
            perf.review_date           review_date,
            perf.last_update_date      last_update_date,
            perf.performance_review_id performance_review_id,
            pevt.type                  perf_review_type,
            NULL                       app_temp_name,
            hri_bpl_perf_rating.get_perf_rating_val (perf.review_date,
              :p_business_group_id,perf.performance_rating,pevt.type,null) nrmlsd_rating,
            nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date
     FROM   per_performance_reviews perf,
            per_events pevt,
            per_all_assignments_f asgn,
            per_periods_of_service ppos
    ';

Line: 732

  l_appr_select_sql :=
    'SELECT to_char(prl.step_value) perf_rating,
            papp.appraisal_date     review_date,
            papp.last_update_date   last_update_date,
            null                    performance_review_id,
            null                    perf_review_type,
            papt.name               app_temp_name,
	    hri_bpl_perf_rating.get_perf_rating_val(papp.appraisal_date ,
	         :p_business_group_id,prl.step_value,null,papt.name)  nrmlsd_rating,
            nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date
     FROM   per_appraisals papp,
            per_rating_levels prl,
            per_appraisal_templates papt,
            per_all_assignments_f asgn,
            per_periods_of_service ppos
    ';

Line: 795

                        ' AND NOT EXISTS (SELECT 1
                                          FROM   per_appraisals papp
                                          WHERE  papp.appraisee_person_id = perf.person_id
                                          AND    papp.event_id            = pevt.event_id
                                          AND    pevt.type                = ''APPRAISAL'')';

Line: 824

    l_perf_sql:= l_perf_select_sql     ||' '||
                 l_perf_where_sql      ||' '||
                 ' UNION ALL '         ||
                 l_appr_select_sql     ||' '||
                 l_appr_where_sql      ||' '||
                 l_appr_asg_where_sql  ||' '||
                 ' ORDER BY 2, 3';

Line: 837

    l_perf_sql:= l_appr_select_sql     ||' '||
                 l_appr_where_sql      ||' '||
                 ' AND    :p_business_group_id is not null
                   AND    papp.appraisee_person_id = :p_person_id
                   AND    papp.appraisal_date <= :p_end_date_active
                   AND    :p_hire_date is not null '||
                 l_appr_asg_where_sql ||
                 ' ORDER BY 2, 3';

Line: 873

  l_outer_select :=
       'select  perf_rating,
                review_date,
                last_update_date,
                nvl((lead(review_date,1) over (order by review_date) - 1),termination_date) end_date,
                performance_review_id,
                perf_review_type,
                app_temp_name,
	        nrmlsd_rating,
                hri_bpl_perf_rating.get_perf_rating_band
                     (nrmlsd_rating,:p_business_group_id,:p_person_id,perf_rating,
                      perf_review_type,app_temp_name ) perf_band,
	        dense_rank() over (partition by review_date
	             order by last_update_date desc)  same_day_rank
         from ( ';

Line: 894

  l_perf_sql := l_outer_select||l_perf_sql||l_outer_where;

Line: 937

  SELECT bb.*
  FROM   bis_bucket_customizations bb,
         bis_bucket b
  WHERE  b.short_name = c_bucket
  AND    b.bucket_id  = bb.bucket_id;

Line: 944

  SELECT full_name
  FROM   per_all_people_f per
  WHERE  per.person_id = p_person_id
  AND    trunc(sysdate) between  per.effective_start_date and effective_end_date;