APPS.HR_US_FF_UDF1 dependencies on PAY_US_STATE_TAX_INFO_F

Line 5637: FROM pay_us_state_tax_info_f

5633: RETURN NUMBER IS
5634:
5635: CURSOR csr_sui_er_wage_limit(p_jurisdiction_code IN VARCHAR2,p_date_earned IN DATE) IS
5636: SELECT NVL(sui_er_wage_limit,0)
5637: FROM pay_us_state_tax_info_f
5638: WHERE state_code = SUBSTR(p_jurisdiction_code,1,2)
5639: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
5640:
5641: l_sui_er_wage_limit pay_us_state_tax_info_f.sui_er_wage_limit%TYPE;

Line 5641: l_sui_er_wage_limit pay_us_state_tax_info_f.sui_er_wage_limit%TYPE;

5637: FROM pay_us_state_tax_info_f
5638: WHERE state_code = SUBSTR(p_jurisdiction_code,1,2)
5639: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
5640:
5641: l_sui_er_wage_limit pay_us_state_tax_info_f.sui_er_wage_limit%TYPE;
5642:
5643: CURSOR csr_sui_ee_wage_limit(p_jurisdiction_code IN VARCHAR2,p_date_earned IN DATE) IS
5644: SELECT NVL(sui_ee_wage_limit,0)
5645: FROM pay_us_state_tax_info_f

Line 5645: FROM pay_us_state_tax_info_f

5641: l_sui_er_wage_limit pay_us_state_tax_info_f.sui_er_wage_limit%TYPE;
5642:
5643: CURSOR csr_sui_ee_wage_limit(p_jurisdiction_code IN VARCHAR2,p_date_earned IN DATE) IS
5644: SELECT NVL(sui_ee_wage_limit,0)
5645: FROM pay_us_state_tax_info_f
5646: WHERE state_code = SUBSTR(p_jurisdiction_code,1,2)
5647: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
5648:
5649: l_sui_ee_wage_limit pay_us_state_tax_info_f.sui_ee_wage_limit%TYPE;

Line 5649: l_sui_ee_wage_limit pay_us_state_tax_info_f.sui_ee_wage_limit%TYPE;

5645: FROM pay_us_state_tax_info_f
5646: WHERE state_code = SUBSTR(p_jurisdiction_code,1,2)
5647: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
5648:
5649: l_sui_ee_wage_limit pay_us_state_tax_info_f.sui_ee_wage_limit%TYPE;
5650:
5651: CURSOR csr_supp_calc_method(p_jurisdiction_code IN VARCHAR2,p_date_earned IN DATE) IS
5652: SELECT NVL(sta_information18,' ')
5653: FROM pay_us_state_tax_info_f

Line 5653: FROM pay_us_state_tax_info_f

5649: l_sui_ee_wage_limit pay_us_state_tax_info_f.sui_ee_wage_limit%TYPE;
5650:
5651: CURSOR csr_supp_calc_method(p_jurisdiction_code IN VARCHAR2,p_date_earned IN DATE) IS
5652: SELECT NVL(sta_information18,' ')
5653: FROM pay_us_state_tax_info_f
5654: WHERE state_code = SUBSTR(p_jurisdiction_code,1,2)
5655: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
5656:
5657: l_supp_calc_meth pay_us_state_tax_info_f.sta_information18%TYPE;

Line 5657: l_supp_calc_meth pay_us_state_tax_info_f.sta_information18%TYPE;

5653: FROM pay_us_state_tax_info_f
5654: WHERE state_code = SUBSTR(p_jurisdiction_code,1,2)
5655: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
5656:
5657: l_supp_calc_meth pay_us_state_tax_info_f.sta_information18%TYPE;
5658:
5659: l_return_value NUMBER;
5660:
5661: BEGIN