APPS.PN_GL_TRANSFER SQL Statements

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

Line: 6

                       P_selection_type          VARCHAR2 ,
                       P_batch_name              VARCHAR2,
                       p_from_date               DATE,
                       p_to_date                 DATE,
                       P_validate_account        VARCHAR2 ,
                       p_gl_transfer_mode        VARCHAR2 ,
                       p_submit_journal_import   VARCHAR2 ,
                       p_process_days            VARCHAR2,
                       p_debug_flag              VARCHAR2

                       )
AS
   l_sob_list              xla_gl_transfer_pkg.t_sob_list := xla_gl_transfer_pkg.t_sob_list();

Line: 31

   SELECT set_of_books_id,
          name,
          currency_code
   FROM  gl_sets_of_books
   WHERE set_of_books_id =l_sob_id;

Line: 68

      SELECT name
        INTO l_org_code
        FROM hr_operating_units
        WHERE organization_id = l_org_id;

Line: 89

      p_selection_type         => p_selection_type,
      p_sob_list               => l_sob_list,
      p_batch_name             => p_batch_name,
      p_source_doc_id          => NULL,
      p_source_document_table  => NULL,
      p_start_date             => P_from_date,
      p_end_date               => P_to_date,
      p_journal_category       => l_je_category,
      p_validate_account       => p_validate_account,
      p_gl_transfer_mode       => p_gl_transfer_mode,
      p_submit_journal_import  => p_submit_journal_import,
      p_summary_journal_entry  => 'N',
      p_process_days           => p_process_days,
      p_batch_desc             => l_desc,
      p_je_desc                => l_desc,
      p_je_line_desc           => NULL,
      p_debug_flag             => p_debug_flag
     );