APPS.PAY_PAYUSDED_XMLP_PKG SQL Statements

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

Line: 11

   select 'x'
     from pay_action_parameters
    where parameter_name = 'TRACE'
      and parameter_value = 'Y';

Line: 17

   select name
     from hr_organization_units
     where organization_id = cp_org_id;

Line: 49

     l_message := 'Error: While Selecting Government Reporting Entity ....';

Line: 63

     l_message := 'Error: While Selecting Organization name ....';

Line: 80

      l_message := 'Error: While Selecting Consolidation_set_name ....';

Line: 81

      select  consolidation_set_name
      into   c_consolidation_set
      from  pay_consolidation_sets
      where consolidation_set_id = p_consolidation_set_id
      and business_group_id = p_business_group_id;

Line: 94

      l_message := 'Error: While Selecting Payroll name ....';

Line: 95

      select payroll_name
      into c_payroll
      from pay_all_payrolls_f
      where payroll_id = p_payroll_id
      and p_end_date between effective_start_date and effective_end_date
      and business_group_id = p_business_group_id;

Line: 109

     l_message := 'Error: While Selecting Element Set name ....';

Line: 110

     select element_set_name
     into c_element_set
     from pay_element_sets
     where element_set_id = p_element_set_id;

Line: 124

     l_message := 'Error: While Selecting Classification name ....';

Line: 125

     select classification_name
     into c_classification
     from pay_element_classifications
     where classification_id = p_classification_id;

Line: 137

     l_message := 'Error: While Selecting Element name ....';

Line: 138

     select element_name
     into c_element_name
     from pay_element_types_f
     where element_type_id = p_element_type_id
     and p_end_date between effective_start_date and effective_end_date;

Line: 151

     l_message := 'Error: While Selecting Location name ....';

Line: 152

     select location_code
     into c_location
     from hr_locations
     where location_id = p_location_id;

Line: 163

     l_message := 'Error: While Selecting Employee name ....';

Line: 164

     select full_name
     into c_person
     from per_people_f
     where person_id = p_person_id
     and p_end_date between effective_start_date and effective_end_date;

Line: 324

  select petr.element_type_id
    from pay_element_type_rules petr
   where petr.element_set_id = cp_element_set_id
     and petr.include_or_exclude = 'I'
  union all
  select pet1.element_type_id
    from pay_element_types_f pet1
   where pet1.classification_id in
              (select classification_id
                 from pay_ele_classification_rules
                where element_set_id = cp_element_set_id)
  minus
  select petr.element_type_id
    from pay_element_type_rules petr
   where petr.element_set_id = cp_element_set_id
     and petr.include_or_exclude = 'E';