APPS.PAY_NO_ALTINN_TFR_PKG SQL Statements

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

Line: 10

    SELECT  transfer_id
    INTO    t_transfer_id
    FROM    pay_no_altinn_transfers
    WHERE   concurrent_request_id = con_requ_id;

Line: 30

    SELECT  substr (legislative_parameters
                   ,instr (legislative_parameters
                          ,p_token_name) + (length (p_token_name) + 1)
                   ,(decode (instr (legislative_parameters
                                  ,' '
                                  ,instr (legislative_parameters
                                         ,p_token_name))
                           ,0
                           ,decode (instr (legislative_parameters
                                          ,p_token_name)
                                   ,0
                                   ,.5
                                   ,length (legislative_parameters))
                           ,instr (legislative_parameters
                                  ,' '
                                  ,instr (legislative_parameters
                                         ,p_token_name)) - (instr (legislative_parameters
                                  ,p_token_name) + (length (p_token_name) + 1)))))
    INTO    l_value
    FROM    pay_payroll_actions
    WHERE   payroll_action_id = p_payroll_action_id;

Line: 72

      SELECT  object_version_number
      FROM    pay_no_altinn_transfers
      WHERE   concurrent_request_id = p_concurrent_request_id;

Line: 153

                  ,p_reciept_last_updated      => NULL);

Line: 159

  PROCEDURE delete_transfer_record
    (p_transfer_id           IN         number
    ,p_object_version_number IN         number
    ,p_save_status           OUT NOCOPY varchar2) IS
  BEGIN
    pay_naf_del.del
                  (p_transfer_id           => p_transfer_id
                  ,p_object_version_number => p_object_version_number);

Line: 170

  END delete_transfer_record;