APPS.PQP_GB_PSI_HRS_HISTORY SQL Statements

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

Line: 111

      g_tab_event_map_cv.DELETE;

Line: 112

      g_tab_asg_status.DELETE;

Line: 113

      g_tab_pen_sch_map_cv.DELETE;

Line: 114

      g_tab_pen_ele_ids.DELETE;

Line: 115

      g_tab_prs_dfn_cv.DELETE;

Line: 116

      g_tab_dated_table.DELETE;

Line: 211

         SELECT user_status
           FROM per_assignment_status_types
          WHERE assignment_status_type_id = p_asg_sts_type_id;

Line: 680

     SELECT assignment_budget_value_id
           ,assignment_id
           ,effective_start_date
           ,effective_end_date
           ,unit
           ,value
       FROM per_assignment_budget_values_f
      WHERE assignment_budget_value_id = p_abv_id
        AND p_effective_date BETWEEN effective_start_date
                                 AND effective_end_date;

Line: 758

     SELECT assignment_attribute_id
           ,effective_start_date
           ,effective_end_date
           ,contract_type
       FROM pqp_assignment_attributes_f
      WHERE assignment_id = p_assignment_id
        AND g_effective_date BETWEEN effective_start_date
                                 AND effective_end_date;

Line: 1272

                  'update type: '
               || l_tab_pay_proc_evnts(g_event_counter).update_type
            );

Line: 1340

              l_tab_pay_proc_evnts(g_event_counter).update_type <>
              g_prev_pay_proc_evnts.update_type OR
              l_tab_pay_proc_evnts(g_event_counter).surrogate_key <>
              g_prev_pay_proc_evnts.surrogate_key OR
              l_tab_pay_proc_evnts(g_event_counter).column_name <>
              g_prev_pay_proc_evnts.column_name OR
              l_tab_pay_proc_evnts(g_event_counter).effective_date <>
              g_prev_pay_proc_evnts.effective_date OR
              l_tab_pay_proc_evnts(g_event_counter).old_value <>
              g_prev_pay_proc_evnts.old_value OR
              l_tab_pay_proc_evnts(g_event_counter).new_value <>
              g_prev_pay_proc_evnts.new_value OR
              l_tab_pay_proc_evnts(g_event_counter).change_values <>
              g_prev_pay_proc_evnts.change_values OR
              l_tab_pay_proc_evnts(g_event_counter).proration_type <>
              g_prev_pay_proc_evnts.proration_type OR
              l_tab_pay_proc_evnts(g_event_counter).event_group_id <>
              g_prev_pay_proc_evnts.event_group_id OR
              l_tab_pay_proc_evnts(g_event_counter).actual_date <>
              g_prev_pay_proc_evnts.actual_date
            THEN

              l_process_flag := 'Y';