APPS.PAY_PAYUSNAC_XMLP_PKG SQL Statements

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

Line: 13

      select parameter_value into l_p_value
      from pay_action_parameters
      where parameter_name = 'TRACE';

Line: 29

select consolidation_set_id into cid
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 61

  select address_line_1,
         address_line_2,
         address_line_3,
         town_or_city,
          region_2,
         postal_code,
         location_code
 from hr_locations_all
  where  location_id = loc_id;

Line: 121

  select consolidation_set_id into cid
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 132

   select distinct to_char(a.payroll_action_id) ||
          '-'||
          to_char(effective_date,'DD-MON-YYYY')||
          '-'||
          b.CONSOLIDATION_SET_NAME ||
          decode(c.PAYROLL_NAME,null,null,'-') ||
          c.PAYROLL_NAME
   into   ret
   from   pay_payroll_actions    a,
          pay_consolidation_sets b,
          pay_payrolls_f         c
   where  a.CONSOLIDATION_SET_ID = b.CONSOLIDATION_SET_ID
   and    a.PAYROLL_ID           = c.PAYROLL_ID (+)
   and    a.ACTION_TYPE          = 'M'
   and    a.ACTION_STATUS        = 'C'
   and    a.payroll_action_id    = p_payroll_action_id;

Line: 157

      SELECT nvl(p1.pmeth_information6,'Y')
        INTO v_flag
        FROM pay_org_payment_methods_f p1,
             pay_payroll_actions p2
       WHERE p1.business_group_id = P_BUSINESS_GROUP_ID
         AND p2.payroll_action_id = P_PAYROLL_ACTION_ID
         AND p1.business_group_id = p2.business_group_id
         AND p1.org_payment_method_id = p2.org_payment_method_id
         AND p1.payment_type_id = p2.payment_type_id;