APPS.PQP_US_SRS_FUNCTIONS SQL Statements

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

Line: 13

   SELECT fed_information1,         -- DBP Payback Limit
          fed_information2,         -- DCP Combined EE ER Limit
          fed_information3,         -- Includable Annual Comp Limit
          fed_information4,         -- Includable Annual Comp GF Limit
          fed_information5,         -- DCP EE Contribution Limit
          fed_information6          -- DBP Contribution Limit (%age)
   FROM   pay_us_federal_tax_info_f
   WHERE  p_effective_date  BETWEEN effective_start_date
                                AND effective_end_date
     AND  fed_information_category = 'SRS LIMITS';

Line: 82

	SELECT effective_date, business_group_id
	FROM   pay_payroll_actions
	WHERE  payroll_action_id=  p_payroll_action_id;

Line: 111

     SELECT EEI_INFORMATION4
       FROM PAY_ELEMENT_TYPE_EXTRA_INFO
      WHERE element_type_id          = c_element_type_id
        AND information_type         = c_information_type ;

Line: 152

     SELECT aei_information5,
            aei_information6
       FROM per_assignment_extra_info paei,
            pay_element_types_f       pet
      WHERE assignment_id     = c_assignment_id
        AND information_type  = 'PQP_US_SRS_PLAN_ASG_INFO'
        AND aei_information4  = pet.element_name
        AND element_type_id   = c_element_type_id
        AND c_effective_date
            BETWEEN NVL(TO_DATE(SUBSTR(aei_information1,1,10),'yyyy/mm/dd')
                       ,c_effective_date)
                AND NVL(TO_DATE(SUBSTR(aei_information2,1,10),'yyyy/mm/dd')
                       ,c_effective_date)
        AND c_effective_date BETWEEN pet.effective_start_date
                                 AND pet.effective_end_date;

Line: 171

      Select pet.element_type_id
        from pay_element_types_f pet
       Where pet.element_name = c_element_name
         and pet.business_group_id = c_business_group_id
         and c_effective_date between pet.effective_start_date
                                  and pet.effective_end_date;

Line: 180

     SELECT aei_information4,
            aei_information5,
            aei_information6
       FROM per_assignment_extra_info paei
      WHERE assignment_id     = c_assignment_id
        AND information_type  = 'PQP_US_SRS_PLAN_ASG_INFO';