APPS.PAY_PAYUSRRS_XMLP_PKG SQL Statements

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

Line: 19

      select ASSIGNMENT_SET_NAME into CP_asg_set_name
        from hr_assignment_sets
        where assignment_set_id = p_asg_set_id;

Line: 28

      Select name into cp_gre_name
                  from hr_organization_units
                  where organization_id = p_tax_unit_id;

Line: 35

      Select distinct ppf.full_name into c_person_name
                                from per_people_f ppf
                                where ppf.person_id = p_person_id;

Line: 41

           Select ppf.full_name into c_person_name
                                from per_people_f ppf,
                                     per_all_assignments_f paa
                                where paa.person_id = ppf.person_id
                                and paa.assignment_number = p_assignment_number;

Line: 50

           Select pec.classification_name into c_classification_name
                                from pay_element_classifications pec
                                where pec.classification_id = p_classification_id;

Line: 57

Select upper(parameter_value)
    into trace
    from pay_action_parameters
   where parameter_name = 'TRACE';

Line: 81

     SELECT meaning
       FROM fnd_common_lookups
      WHERE lookup_type=element_information_category
        AND lookup_code=element_information1;

Line: 99

      SELECT name
        FROM hr_organization_units
       WHERE organization_id = fp_business_group_id;