APPS.PO_POXPOPAR_XMLP_PKG SQL Statements

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

Line: 47

     SELECT displayed_field
     INTO l_sort
     FROM po_lookup_codes
     WHERE lookup_code = P_ORDERBY
     AND lookup_type = 'SRS ORDER BY';

Line: 72

select meaning
  into w_meaning
  from fnd_lookups
 where lookup_type = p_lookup_type
   and lookup_code = p_lookup_code ;

Line: 134

SELECT   fsa1.application_column_name , fsa2.application_column_name  into
           lex_cost_center,lex_company_name
FROM     gl_sets_of_books              gsb
,        financials_system_parameters  fsp
,        fnd_segment_attribute_values  fsa1
,        fnd_segment_attribute_values  fsa2
WHERE    gsb.set_of_books_id           = fsp.set_of_books_id
AND      fsa1.id_flex_code             = 'GL#'
AND      fsa1.id_flex_num              = gsb.chart_of_accounts_id
AND      fsa1.segment_attribute_type   = 'FA_COST_CTR'
AND      fsa1.attribute_value          = 'Y'
AND      fsa2.id_flex_code             = 'GL#'
AND      fsa2.id_flex_num              = gsb.chart_of_accounts_id
AND      fsa2.segment_attribute_type   = 'GL_BALANCING'
AND      fsa2.attribute_value          = 'Y' ;