APPS.PAY_IP_RULES SQL Statements

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

Line: 85

        SELECT tag
          FROM fnd_lookup_values
         WHERE lookup_type = 'MX_SS_SPL_CHARS'
           AND lookup_code = cp_hex_code;

Line: 174

         SELECT hou.business_group_id
         FROM hr_organization_units hou
         WHERE hou.organization_id = p_tax_unit_id;

Line: 179

         SELECT paaf.business_group_id
          FROM  per_all_assignments_f paaf, pay_assignment_actions paa
         WHERE  paa.assignment_action_id = cp_assignment_action_id
          AND   paa.assignment_id = paaf.assignment_id
          AND   sysdate BETWEEN paaf.effective_start_date
                        AND paaf.effective_end_date;

Line: 187

         SELECT tax_unit_id
         FROM pay_assignment_actions
         WHERE assignment_action_id = p_asg_action_id;

Line: 192

         SELECT hou.name
               ,hou.location_id
           FROM hr_organization_units hou
               ,hr_organization_information hoi
          WHERE hou.organization_id = p_org_id
            AND hoi.organization_id = hou.organization_id
            AND hoi.org_information1 = 'HR_LEGAL';

Line: 201

          SELECT DISTINCT hou.name
               ,hou.location_id
           FROM hr_organization_units hou
               ,hr_organization_information hoi
               ,per_all_assignments_f paaf
               ,pay_assignment_actions paa
          WHERE paa.assignment_action_id = cp_assignment_action_id
            AND paa.assignment_id = paaf.assignment_id
            AND hou.organization_id = paaf.organization_id
            AND hoi.organization_id = hou.organization_id;

Line: 213

         SELECT location.address_line_1,
                location.address_line_2, location.address_line_3,
                location.town_or_city, location.postal_code,
                location.country,location.region_2
           FROM hr_locations location
          WHERE location.location_id = p_location_id;

Line: 221

         SELECT ppf.per_information1,
	        ppf.first_name,
		ppf.last_name,
		ppf.middle_names,
		ppf.order_name,
                ppf.full_name,
		paf.payroll_id
         FROM pay_assignment_actions paa,
              pay_payroll_actions ppa,
              per_assignments_f paf,
              per_people_f      ppf
         WHERE paa.assignment_action_id = p_asg_action_id
         AND paa.payroll_action_id = ppa.payroll_action_id
         AND paf.assignment_id = paa.assignment_id
         AND ppa.effective_date BETWEEN paf.effective_start_date
                                AND paf.effective_end_date
         AND paf.person_id = ppf.person_id
         AND ppa.effective_date BETWEEN ppf.effective_start_date
                                AND ppf.effective_end_date;

Line: 242

         SELECT payroll_name
				 FROM   pay_payrolls_f
				 where  payroll_id = p_payroll_id;

Line: 248

     SELECT nvl(ORG_INFORMATION2,NULL) FROM
       hr_organization_information
       WHERE organization_id = cp_business_group_id
       AND ORG_INFORMATION_CONTEXT = cp_legislation_code||'_REPORTING_PREFERENCES';

Line: 254

      SELECT org_information9
        FROM hr_organization_information
       WHERE org_information_context = 'Business Group Information'
         AND organization_id = cp_business_group;

Line: 260

       SELECT ppa.business_group_id, hoi.org_information9
        FROM hr_organization_information hoi, pay_payroll_actions ppa
       WHERE hoi.org_information_context = 'Business Group Information'
         AND hoi.organization_id = ppa.business_group_id
         AND ppa.payroll_action_id = cp_payroll_action_id;