APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_STATE_TAX_INFO_F

Line 904: PAY_US_STATE_TAX_INFO_F ti

900: ti.sui_ee_wage_limit,
901: ti.sui_er_wage_limit,
902: ti.STA_INFORMATION21
903: FROM PAY_US_STATES st,
904: PAY_US_STATE_TAX_INFO_F ti
905: WHERE v_effective_date BETWEEN
906: ti.effective_start_date AND ti.effective_end_date
907: and st.state_code =
908: ti.state_code

Line 1047: ** as used in PAY_US_STATE_TAX_INFO_F for NY

1043: /*
1044: ** Medicare EE and ER should have an infinite limit,
1045: ** at a later stage a legislative limit may be defined,
1046: ** therefore set to an arbitary value (99,999,999),
1047: ** as used in PAY_US_STATE_TAX_INFO_F for NY
1048: */
1049: l_limit := 99999999;
1050:
1051: l_limit_subject_bal:= pay_us_tax_bals_pkg.us_tax_balance(

Line 2230: FROM pay_us_state_tax_info_f

2226: l_exists VARCHAR2(1) := 'N';
2227:
2228: CURSOR sdi_er_exists IS
2229: SELECT 'Y'
2230: FROM pay_us_state_tax_info_f
2231: WHERE state_code = SUBSTR(p_jd_code, 1, 2)
2232: AND sdi_er_wage_limit IS NOT NULL
2233: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2234:

Line 2237: FROM pay_us_state_tax_info_f

2233: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2234:
2235: CURSOR sdi_ee_exists IS
2236: SELECT 'Y'
2237: FROM pay_us_state_tax_info_f
2238: WHERE state_code = SUBSTR(p_jd_code, 1, 2)
2239: AND sdi_ee_wage_limit IS NOT NULL
2240: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2241:

Line 2244: FROM pay_us_state_tax_info_f

2240: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2241:
2242: CURSOR sdi1_ee_exists IS
2243: SELECT 'Y'
2244: FROM pay_us_state_tax_info_f
2245: WHERE state_code = SUBSTR(p_jd_code, 1, 2)
2246: AND STA_INFORMATION21 IS NOT NULL
2247: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2248:

Line 2251: FROM pay_us_state_tax_info_f

2247: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2248:
2249: CURSOR sui_er_exists is
2250: SELECT 'Y'
2251: FROM pay_us_state_tax_info_f
2252: WHERE state_code = substr(p_jd_code, 1, 2)
2253: AND sui_er_wage_limit IS NOT NULL
2254: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2255:

Line 2258: FROM pay_us_state_tax_info_f

2254: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2255:
2256: CURSOR sui_ee_exists is
2257: SELECT 'Y'
2258: FROM pay_us_state_tax_info_f
2259: WHERE state_code = substr(p_jd_code, 1, 2)
2260: AND sui_ee_wage_limit IS NOT NULL
2261: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2262:

Line 2265: FROM pay_us_state_tax_info_f

2261: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2262:
2263: CURSOR sit_exists is
2264: SELECT sit_exists
2265: FROM pay_us_state_tax_info_f
2266: WHERE state_code = substr(p_jd_code, 1, 2)
2267: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2268:
2269: CURSOR county_exists is