APPS.AR_ARXPOMR_XMLP_PKG SQL Statements

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

Line: 12

    SELECT user_conversion_type
     INTO   l_meaning
     FROM   GL_DAILY_CONVERSION_TYPES
     WHERE conversion_type = po_value;

Line: 21

      SELECT  meaning
       INTO l_meaning
      FROM ar_lookups
      WHERE lookup_type = 'YES/NO'
            and lookup_code = po_value;

Line: 31

     select MEANING
     into   l_meaning
     from   AR_LOOKUPS
     where  lookup_type='DOC_SEQ_GEN_LEVEL'
           and lookup_code = po_value;

Line: 42

     SELECT meaning
       INTO l_meaning
       FROM ar_lookups
        WHERE lookup_type = 'PA_CODE'
            and to_number(decode(lookup_code,'UNDEFINED','-1',lookup_code))
                 = DECODE(po_value,'UNDEFINED',-1,po_value);

Line: 54

      select MEANING
       into l_meaning
       from AR_LOOKUPS
      where lookup_type = 'AR_ZENGIN_CHAR_SET'
             and lookup_code = po_value;

Line: 80

   SELECT  fpo.profile_option_id
      INTO   l_po_id
       FROM   fnd_profile_options fpo,
           fnd_profile_options_tl fpo_tl
       WHERE
        fpo.profile_option_name  = 'ORG_ID'
        AND fpo.profile_option_name = fpo_tl.profile_option_name
        AND fpo_tl.language         = USERENV('LANG');

Line: 105

   SELECT  fpo.profile_option_id
      INTO   l_po_id
       FROM   fnd_profile_options fpo,
           fnd_profile_options_tl fpo_tl
       WHERE
        fpo.profile_option_name  = 'ORG_ID'
        AND fpo.profile_option_name = fpo_tl.profile_option_name
        AND fpo_tl.language         = USERENV('LANG');

Line: 145

     SELECT    fpo_tl.user_profile_option_name
      INTO l_po_user_name
      FROM fnd_profile_options fpo,
           fnd_profile_options_tl fpo_tl
      WHERE
        fpo.profile_option_name =po_name
      AND fpo.profile_option_name = fpo_tl.profile_option_name
      AND fpo_tl.language         = USERENV('LANG')
      ORDER BY fpo.profile_option_name;