APPS.PAY_US_MMREF_FUNCTION_PKG SQL Statements

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

Line: 79

  SELECT city_name
  FROM pay_us_city_names
  WHERE state_code = substr(c_jurisdiction_code,1,2)
  AND   county_code = substr(c_jurisdiction_code,4,3)
  AND city_code = substr(c_jurisdiction_code,8,4)
  AND primary_flag = 'Y';

Line: 91

  SELECT substr(city_information1,1,5),
         substr(city_information1,6)
  FROM  pay_us_city_tax_info_f
  WHERE  to_date(c_date,'dd-mm-yyyy') between effective_start_date
                and effective_end_date
  AND jurisdiction_code = c_jurisdiction_code;

Line: 430

SELECT USER_ENTITY_ID
FROM   FF_USER_ENTITIES
WHERE  USER_ENTITY_NAME = C_USER_NAME;

Line: 439

SELECT SUM(FAI.VALUE),COUNT(FAI.ARCHIVE_ITEM_ID)
FROM FF_ARCHIVE_ITEMS FAI,
      PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAA.PAYROLL_ACTION_ID = C_PAYROLL_ACTION_ID
AND   PAA.TAX_UNIT_ID = C_TAX_UNIT_ID
AND   FAI.CONTEXT1 = TO_CHAR(PAA.ASSIGNMENT_ACTION_ID)
AND   FAI.USER_ENTITY_ID = C_USER_ENTITY_ID
AND   FAI.VALUE >= 0;