APPS.PAY_PAYCNSOE_XMLP_PKG SQL Statements

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

Line: 40

  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: 61

  select currency_code
  from   fnd_currencies
  where  issuing_territory_code = c_territory_code;

Line: 190

   SELECT ppf.payroll_name
   FROM   pay_payrolls_f ppf
   WHERE  ppf.payroll_id = P_PAYROLL_ID
   AND    ppf.business_group_id = P_BUSINESS_GROUP_ID
  -- AND    P_START_DATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;

Line: 198

   SELECT  pcs.consolidation_set_name
   FROM    pay_consolidation_sets pcs
   WHERE   pcs.consolidation_set_id = P_CONSOLIDATION_SET_ID
   AND     pcs.business_group_id = P_BUSINESS_GROUP_ID ;

Line: 204

   SELECT pbg.name
   FROM   per_business_groups pbg
   WHERE  pbg.organization_id = P_BUSINESS_GROUP_ID ;