APPS.PAY_SOE_UTIL SQL Statements

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

Line: 7

select org_information2 elements1
,      org_information3 elements2
,      org_information4 elements3
,      org_information5 elements4
,      org_information6 elements5
,      org_information7 elements6
,      org_information8 information1
,      org_information9 balances1
,      org_information10 balances2
,      org_information11 balances3
from   hr_organization_information
where  organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
and    org_information_context = 'Business Group:SOE Information'
and    org_information1 = fnd_profile.value('PAY_SOE_USER_CATEGORY');

Line: 46

lastcol indicate the select statements first and last columns (used
to format the statement correctly
----------------------------------------------------------------------- */
procedure setValue(name varchar2
                  ,value varchar2
                  ,firstCol BOOLEAN
                  ,lastCol BOOLEAN) is
begin
   if g_debug then
     hr_utility.trace('colid  = ' || name || value);

Line: 74

   dataValueTab.delete;

Line: 83

   select 'a' COL1, 'b' COL2 from dual
   union
   select 'c' COL1, 'd' COL2 from dual;

Line: 93

        l_sql_string := l_sql_string ||'select ';     else

Line: 163

select f.flex_value_set_id
from   fnd_id_flex_segments f
,      fnd_flex_validation_tables t
where  f.id_flex_code = p_id_flex_code
and    f.id_flex_num = p_id_flex_num
and    f.application_column_name = p_application_column_name
and    f.flex_value_set_id = t.flex_value_set_id;

Line: 211

select decode(substr(meaning,1,3)
             ,p_legislation_code||'_',substr(meaning,4,length(meaning)-3)
             ,meaning)
from   hr_lookups
where  lookup_type = p_segment_type
and    lookup_code = p_legislation_code;

Line: 230

     l_sql := 'select id_flex_num,'||l_segment||
              ' from pay_external_accounts '||
              ' where external_account_id = :eaId';

Line: 273

  select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;

Line: 274

  select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;