APPS.IGI_ITR_ACCT_GENERATOR_PKG SQL Statements

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

Line: 172

            select to_char(sysdate,'DD-MON-RRRR')
            into   p_char_date
            FROM   dual;

Line: 334

     SELECT creation_ccid
     INTO   l_creation_ccid
     FROM   igi_itr_charge_service serv
     WHERE  serv.charge_center_id = l_charge_center_id
     AND    serv.charge_service_id = l_charge_service_id
     AND    sysdate BETWEEN nvl(serv.start_date,sysdate)
                    AND nvl(serv.end_date,sysdate);

Line: 413

      SELECT count(*)
      INTO   l_no_of_segs
      FROM   fnd_id_flex_segments
      WHERE  application_id = 101
      AND    id_flex_code = 'GL#'
      AND    id_flex_num = l_coa_id;

Line: 574

   EXECUTE immediate  'SELECT '||l_segmenti_number||
                     ' FROM    igi_itr_charge_orig orig'||
                            ' ,igi_itr_charge_center center'||
                     ' WHERE orig.originator_id = :preparer_id'||
                     ' AND   sysdate BETWEEN nvl(orig.start_date,sysdate)'||
                                   ' AND nvl(orig.end_date,sysdate) '||
                     ' AND   orig.charge_center_id = center.charge_center_id'||
                     ' AND   center.set_of_books_id = :set_of_books_id'||
                     ' AND   sysdate BETWEEN'||
                             ' nvl(center.start_date_active,sysdate)'||
                             ' AND nvl(center.end_date_active,sysdate)'
   INTO l_segmenti_value
   USING  l_preparer_id, l_set_of_books_id;

Line: 660

      SELECT segment_name
      INTO   l_segmenti_name
      FROM   fnd_id_flex_segments
      WHERE  application_id = 101
      AND    id_flex_code = 'GL#'
      AND    id_flex_num  = l_coa_id
      AND    application_column_name = l_segmenti_number;

Line: 827

           SELECT segment_name
           INTO   l_additional_seg_name
           FROM   igi_itr_charge_setup
           WHERE  set_of_books_id = l_sob_id;

Line: 888

           SELECT receiving_ccid
           INTO   l_service_receiving_ccid
           FROM   igi_itr_charge_service serv
           WHERE  serv.charge_service_id = l_charge_service_id
           AND    serv.charge_center_id = l_charge_center_id
           AND    sysdate BETWEEN nvl(serv.start_date,sysdate)
                          AND nvl(serv.end_date,sysdate);