APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_STATES

Line 781: FROM PAY_US_STATES st,

777: SELECT ti.sdi_ee_wage_limit,
778: ti.sdi_er_wage_limit,
779: ti.sui_ee_wage_limit,
780: ti.sui_er_wage_limit
781: FROM PAY_US_STATES st,
782: PAY_US_STATE_TAX_INFO_F ti
783: WHERE v_effective_date BETWEEN
784: ti.effective_start_date AND ti.effective_end_date
785: and st.state_code =

Line 1683: FROM PAY_US_STATES

1679: c_proc VARCHAR2(100) := 'derive_jd_geocode';
1680:
1681: CURSOR csr_state_code IS
1682: SELECT state_code
1683: FROM PAY_US_STATES
1684: WHERE state_abbrev = p_state_abbrev
1685: ;
1686:
1687: CURSOR csr_county_code IS

Line 1691: PAY_US_STATES s

1687: CURSOR csr_county_code IS
1688: SELECT cn.state_code,
1689: cn.county_code
1690: FROM PAY_US_COUNTIES cn,
1691: PAY_US_STATES s
1692: WHERE cn.county_name = p_county_name
1693: and cn.state_code = s.state_code
1694: and s.state_abbrev = p_state_abbrev
1695: ;

Line 1703: PAY_US_STATES pus

1699: -- the employee's assignment
1700: CURSOR csr_chk_state IS
1701: SELECT 'PASS'
1702: FROM PAY_US_EMP_STATE_TAX_RULES st,
1703: PAY_US_STATES pus
1704: WHERE st.assignment_id = p_assignment_id
1705: and st.state_code = pus.state_code
1706: and pus.state_abbrev = p_state_abbrev
1707: ;

Line 2073: pay_us_states pus

2069: fed.ss_tax_exempt
2070: FROM pay_us_emp_fed_tax_rules_f fed,
2071: PER_ASSIGNMENTS_F a,
2072: PER_BUSINESS_GROUPS bg,
2073: pay_us_states pus
2074: WHERE fed.assignment_id = a.assignment_id
2075: and a.assignment_number = p_assignment_number
2076: and a.business_group_id = bg.business_group_id
2077: and bg.name ||'' = p_business_group_name

Line 2147: pay_us_states pus

2143: sta.sui_exempt
2144: FROM pay_us_emp_state_tax_rules_f sta,
2145: PER_ASSIGNMENTS_F a,
2146: PER_BUSINESS_GROUPS bg,
2147: pay_us_states pus
2148: WHERE sta.assignment_id = a.assignment_id
2149: and a.assignment_number = p_assignment_number
2150: and a.business_group_id = bg.business_group_id
2151: and bg.name ||'' = p_business_group_name

Line 2166: pay_us_states pus

2162: cnt.sd_exempt
2163: FROM pay_us_emp_county_tax_rules_f cnt,
2164: PER_ASSIGNMENTS_F a,
2165: PER_BUSINESS_GROUPS bg,
2166: pay_us_states pus
2167: WHERE cnt.assignment_id = a.assignment_id
2168: and a.assignment_number = p_assignment_number
2169: and a.business_group_id = bg.business_group_id
2170: and bg.name ||'' = p_business_group_name

Line 2185: pay_us_states pus

2181: cty.sd_exempt
2182: FROM pay_us_emp_city_tax_rules_f cty,
2183: PER_ASSIGNMENTS_F a,
2184: PER_BUSINESS_GROUPS bg,
2185: pay_us_states pus
2186: WHERE cty.assignment_id = a.assignment_id
2187: and a.assignment_number = p_assignment_number
2188: and a.business_group_id = bg.business_group_id
2189: and bg.name ||'' = p_business_group_name