APPS.PAY_PYSG8SAD_XMLP_PKG SQL Statements

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

Line: 9

  t := DELETE_ARCHIVE_DATA(p_payroll_action_id);

Line: 38

   select org_information7
   from   hr_organization_information
   where  org_information_context = 'SG_LEGAL_ENTITY'
   and    organization_id = c_legal_entity_id;

Line: 45

  select org_information9
  from   hr_organization_information
  where  organization_id  = c_business_group_id
  and    org_information9 is not null;

Line: 81

  select currency_code
  from   fnd_currencies
  where  issuing_territory_code = c_territory_code;

Line: 241

  function delete_archive_data(t_payroll_action_id in number) return number is

  cursor c_get_asact_id
  (c_pact_id in pay_payroll_actions.payroll_action_id%type) is
  select distinct assignment_action_id
    from pay_assignment_actions
   where payroll_action_id = t_payroll_action_id;

Line: 251

  select distinct archive_item_id
    from ff_archive_items
   where context1= c_asact_id;

Line: 272

               delete from ff_archive_item_contexts where archive_item_id = v_archive_item_id;

Line: 273

		       delete from ff_archive_items where archive_item_id = v_archive_item_id;