APPS.PAY_BACM SQL Statements

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

Line: 14

      select prrv.result_value into rr_date
          from
                  pay_element_types                 pet,
                 pay_input_values                  piv,
                 pay_run_result_values             prrv,
                  pay_run_results                   prr
           where  prr.assignment_action_id
                          = assign_act_id
           and    prrv.run_result_id
                         = prr.run_result_id
           and    pet.element_type_id
                         = prr.element_type_id
           and    pet.element_name
                         = 'BACS Process Date'
           and    piv.input_value_id
                          = prrv.input_value_id
           and    piv.name
                          = 'Process Date';