APPS.PQP_GB_PENSION_FUNCTIONS SQL Statements

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

Line: 389

        SELECT eei_information4, --Scheme Category
               eei_information8  --Scheme Type(COSR/COMP)
        FROM pay_element_type_extra_info
        WHERE element_type_id = c_element_type_id
        AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';

Line: 885

         SELECT input_value_id
           FROM pay_input_values_f
          WHERE NAME = p_input_value_name
            AND element_type_id = c_element_type_id
            AND p_effective_date BETWEEN effective_start_date
                                     AND effective_end_date;

Line: 957

         SELECT screen_entry_value
           FROM pay_element_entry_values_f
          WHERE element_entry_id = p_element_entry_id
            AND input_value_id = p_input_value_id
            AND effective_start_date = p_effective_start_date
            AND effective_end_date = p_effective_end_date;

Line: 1239

      SELECT employee_deduction_method
        FROM pqp_gb_pension_schemes_v
       WHERE element_type_id = p_element_type_id;