APPS.AR_CONFIRMATION SQL Statements

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

Line: 10

      select DISTINCT 'FND_RESP222:'||to_char(responsibility_id) role_name
      from fnd_responsibility_tl
      where application_id = 222;

Line: 14

      select handler_name, handler_type from ar_confirmation_actions
      where status = p_status and (reason_code = p_reason_code or p_reason_code is null);

Line: 17

      select msgid from ecx_doclogs where internal_control_number = p_int_ctr_num;

Line: 28

      select application_id, responsibility_id, last_updated_by
      from ar_document_transfers
      where document_transfer_id = l_doc_transfer_id;

Line: 39

       global_rec.last_updated_by is null then
      fnd_message.set_name('AR','AR_CONF_ACT_INV_ID_SBJ');

Line: 48

      fnd_global.initialize(l_sid, global_rec.last_updated_by, global_rec.responsibility_id,
                            global_rec.application_id, null,null,0,0,null,null,null,null);

Line: 92

      l_parameter_list.DELETE;