DBA Data[Home] [Help]

APPS.PAY_PAYSG21A_XMLP_PKG SQL Statements

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

Line: 57

  select org_information9
  from   hr_organization_information
  where  organization_id  = c_business_group_id
  and    org_information9 is not null
  and    org_information_context = 'Business Group Information';
Line: 78

  select currency_code
  from   fnd_currencies
  where  issuing_territory_code = c_territory_code;