APPS.IGI_EXP_CUSTOM SQL Statements

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

Line: 11

   SELECT COUNT(du.status)
   FROM   wf_notification_attributes WNA
   ,      wf_notifications WN
   ,      wf_message_attributes WMA
   ,      igi_exp_dial_unit_def DU
   ,      igi_exp_tran_unit_def TU
   WHERE  WNA.notification_id = pv_notification_id
   AND    WNA.name            = 'TRANS_UNIT_NUM'
   AND    WNA.notification_id = WN.notification_id
   AND    WN.message_type     = WMA.message_type
   AND    WN.message_name     = WMA.message_name
   AND    WMA.name            = WNA.name
   AND    WNA.text_value      = TU.trans_unit_num
   AND    DU.trans_unit_id    = TU.trans_unit_id
   AND    DU.status           IN ('TRA','HOL') ;