APPS.CSTPGLXF SQL Statements

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

Line: 80

   SELECT
   count(*)
   INTO
   l_le_exists
   FROM
   cst_le_cost_types
   WHERE
   legal_entity = p_legal_entity AND
   post_to_gl ='Y';

Line: 104

   SELECT
   count(*)
   INTO
   l_ct_exists
   FROM
   cst_le_cost_types clct,
   cst_cost_types cct
   WHERE clct.legal_entity = p_legal_entity AND
   clct.cost_type_id = p_cost_type_id AND
   clct.post_to_gl = 'Y' AND
   clct.cost_type_id = cct.cost_type_id AND
   NVL(cct.disable_date, SYSDATE +1) > SYSDATE;

Line: 129

   SELECT
   count(*)
   INTO
   l_cg_exists
   FROM
   cst_cost_groups ccg
   WHERE legal_entity = p_legal_entity AND
   cost_group_id = p_cost_group_id;

Line: 152

   SELECT
   count(*)
   INTO
   l_per_exists
   FROM
   cst_pac_periods
   WHERE open_flag = 'N' AND
   legal_entity = p_legal_entity AND
   cost_type_id = p_cost_type_id AND
   pac_period_id = p_period_id;

Line: 174

   SELECT
   clct.set_of_books_id,
   glsob.name
   INTO
   l_set_of_books_id,
   l_sob_name
   FROM
   cst_le_cost_types clct,
   gl_sets_of_books glsob
   WHERE
   clct.legal_entity = p_legal_entity AND
   clct.cost_type_id = p_cost_type_id AND
   clct.set_of_books_id = glsob.set_of_books_id;

Line: 195

   SELECT
   currency_code
   INTO
   l_base_currency_code
   FROM
   gl_sets_of_books
   WHERE
   set_of_books_id = l_set_of_books_id;

Line: 213

   SELECT
   period_start_date,
   period_end_date
   INTO
   l_start_date,
   l_end_date
   FROM
   cst_pac_periods
   WHERE
   pac_period_id = p_period_id;

Line: 265

			 p_selection_type         => 1,
			 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             => l_start_date,
			 p_end_date               => l_end_date,
			 p_journal_category       => l_ae_category,
			 p_gl_transfer_mode       => p_gl_transfer_mode,
			 p_submit_journal_import  => p_submit_journal_import,
			 p_summary_journal_entry  => 'N',
			 p_process_days           => NULL,
			 p_batch_desc             => p_legal_entity || ' ' || p_cost_type_id || ' ' || p_cost_group_id || ' ' || p_batch_name,
			 p_je_desc                => p_legal_entity || ' ' || p_cost_type_id || ' ' || p_cost_group_id || ' ' || p_batch_name,
			 p_je_line_desc           => p_legal_entity || ' ' || p_cost_type_id || ' ' || p_cost_group_id || ' ' || p_batch_name,
			 p_debug_flag             => p_debug_flag
					 );