APPS.CSM_DEBRIEF_HEADER_EVENT_PKG SQL Statements

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

Line: 32

SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
FROM   csf_debrief_headers dhdr,
	   jtf_task_assignments jta,
	   jtf_rs_resource_extns jtrs
WHERE dhdr.debrief_header_id = p_debrief_header_id
AND  jta.task_assignment_id = dhdr.task_assignment_id
AND  jtrs.resource_id (+)= jta.resource_id
;

Line: 103

  CSM_ACC_PKG.Insert_Acc
  ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
   ,P_ACC_TABLE_NAME         => g_debrief_acc_table_name
   ,P_SEQ_NAME               => g_debrief_seq_name
   ,P_PK1_NAME               => g_debrief_pk1_name
   ,P_PK1_NUM_VALUE          => p_debrief_header_id
   ,P_USER_ID                => p_user_id
  );

Line: 136

SELECT dhdr.task_assignment_id, acc.user_id
FROM   csf_debrief_headers dhdr,
       csm_debrief_headers_acc acc
WHERE dhdr.debrief_header_id = p_debrief_header_id
AND  acc.debrief_header_id = dhdr.debrief_header_id
AND  acc.user_id = p_user_id;

Line: 199

   CSM_ACC_PKG.Delete_Acc
   ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
    ,P_ACC_TABLE_NAME         => g_debrief_acc_table_name
    ,P_PK1_NAME               => g_debrief_pk1_name
    ,P_PK1_NUM_VALUE          => p_debrief_header_id
    ,P_USER_ID                => p_user_id
   );

Line: 239

      CSM_ACC_PKG.Update_Acc
      ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
       ,P_ACC_TABLE_NAME         => g_debrief_acc_table_name
       ,P_USER_ID                => p_user_id
       ,p_ACCESS_ID              => l_access_id
      );