APPS.AP_APXUCPRP_XMLP_PKG SQL Statements

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

Line: 39

   SELECT  ly.meaning,
           ln.meaning,
           l1.displayed_field,
           l2.displayed_field,
           l3.displayed_field,
           l4.displayed_field
   INTO    nls_yes,
	   nls_no,
	   nls_all,
	   nls_void,
	   nls_na,
           nls_pay_method
   FROM    fnd_lookups ly,
	   fnd_lookups ln,
	   ap_lookup_codes l1,
	   ap_lookup_codes l2,
	   ap_lookup_codes l3,
           ap_lookup_codes l4
   WHERE   ly.lookup_type = 'YES_NO'
     AND   ly.lookup_code = 'Y'
     AND   ln.lookup_type = 'YES_NO'
     AND   ln.lookup_code = 'N'
     AND   l1.lookup_type = 'NLS REPORT PARAMETER'
     AND   l1.lookup_code = 'ALL'
     AND   l2.lookup_type = 'NLS TRANSLATION'
     AND   l2.lookup_code = 'VOID'
     AND   l3.lookup_type = 'NLS REPORT PARAMETER'
     AND   l3.lookup_code = 'NA'
     AND   l4.lookup_type = 'PAYMENT METHOD'
     AND   (l4.lookup_code = P_PMT_METHOD OR P_PMT_METHOD IS NULL);

Line: 79

   SELECT  ly.meaning,
           ln.meaning,
           l1.displayed_field,
           l2.displayed_field,
           l3.displayed_field
   INTO    nls_yes,
	   nls_no,
	   nls_all,
	   nls_void,
	   nls_na
   FROM    fnd_lookups ly,
	   fnd_lookups ln,
	   ap_lookup_codes l1,
	   ap_lookup_codes l2,
	   ap_lookup_codes l3
   WHERE   ly.lookup_type = 'YES_NO'
     AND   ly.lookup_code = 'Y'
     AND   ln.lookup_type = 'YES_NO'
     AND   ln.lookup_code = 'N'
     AND   l1.lookup_type = 'NLS REPORT PARAMETER'
     AND   l1.lookup_code = 'ALL'
     AND   l2.lookup_type = 'NLS TRANSLATION'
     AND   l2.lookup_code = 'VOID'
     AND   l3.lookup_type = 'NLS REPORT PARAMETER'
     AND   l3.lookup_code = 'NA';

Line: 261

     SELECT  name,
             chart_of_accounts_id
     INTO    l_name,
             l_chart_of_accounts_id
     FROM    gl_sets_of_books
     WHERE   set_of_books_id = l_sob_id;

Line: 288

  SELECT multi_org_flag
  INTO   multi_org_installation
  FROM   fnd_product_groups
  WHERE  product_group_id = 1 ;

Line: 295

    SELECT mrc_sob_type_code INTO l_sob_type_code
    FROM gl_sets_of_books WHERE set_of_books_id = p_set_of_books_id;

Line: 323

    c_select_le := 'le.name' ;

Line: 324

    c_select_ou := 'ou.name' ;

Line: 330

    c_select_le := '''Legal Entity''' ;

Line: 331

    c_select_ou := '''Operating Unit''' ;

Line: 360

   SELECT CBA.bank_account_name
     INTO cp_bank_account_name
     FROM ce_bank_accounts CBA, ce_bank_acct_uses_all CBAU
    WHERE  CBA.bank_account_id  =  CBAU.bank_account_id
     AND  CBAU.bank_acct_use_id = p_bank_account_id;

Line: 444

 Function C_SELECT_LE_p return varchar2 is
	Begin
	 return C_SELECT_LE;

Line: 448

 Function C_SELECT_OU_p return varchar2 is
	Begin
	 return C_SELECT_OU;