APPS.PAY_US_ONLINE_W4_XML_PKG SQL Statements

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

Line: 55

      CURSOR c_get_updated_values (cp_transaction_step_id IN NUMBER)
      IS
         SELECT fs.varchar2_value fs_value, allo.number_value allo_value,
                aa.number_value aa_value, ex.varchar2_value ex_value,
                lnd.varchar2_value lnd_value
           FROM hr_api_transaction_values fs,
                hr_api_transaction_values allo,
                hr_api_transaction_values aa,
                hr_api_transaction_values ex,
                hr_api_transaction_values lnd
          WHERE fs.transaction_step_id = cp_transaction_step_id
            AND fs.NAME = 'P_FILING_STATUS'
            AND allo.transaction_step_id = fs.transaction_step_id
            AND allo.NAME = 'P_ALLOWANCES'
            AND aa.transaction_step_id = fs.transaction_step_id
            AND aa.NAME = 'P_ADDITIONAL_TAX'
            AND ex.transaction_step_id = fs.transaction_step_id
            AND ex.NAME = 'P_EXEMPT'
            AND lnd.transaction_step_id = fs.transaction_step_id
            AND lnd.NAME = 'P_LAST_NAME_DIFF';

Line: 78

         SELECT ppf.first_name,
	        SUBSTR (ppf.middle_names, 1, 1) middle_initial,
                ppf.last_name,
                ppf.national_identifier,
                pad.address_line1,
		pad.address_line2,
		pad.address_line3,
                pad.town_or_city || ', ' || pad.region_2 || ', ' || pad.postal_code city_town_zip
           FROM per_people_f ppf, per_addresses pad
          WHERE ppf.person_id = cp_person_id
            AND ppf.person_id = pad.person_id
            AND trunc(sysdate) between ppf.effective_start_date
                                   and ppf.effective_end_date
            AND pad.primary_flag = 'Y'
            AND trunc(sysdate) between pad.date_from
                                   and nvl(pad.date_to, trunc(sysdate));

Line: 97

         SELECT lookup_code
           FROM fnd_common_lookups fcl
          WHERE lookup_type = 'US_FIT_FILING_STATUS'
            AND application_id = 800
            AND meaning = cp_meaning;

Line: 150

      OPEN c_get_updated_values (p_transaction_step_id);

Line: 152

      FETCH c_get_updated_values
       INTO l_filing_status, l_allowances, l_additional_amount, l_exempt,
            l_last_name_diff;

Line: 156

      CLOSE c_get_updated_values;

Line: 181

      SELECT SYSDATE, TO_CHAR (SYSDATE, 'YYYY')
        INTO l_date, l_year
        FROM DUAL;