APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on PAY_US_STATES

Line 576: FROM PAY_US_STATES st,

572: SELECT ti.sdi_ee_wage_limit,
573: ti.sdi_er_wage_limit,
574: ti.sui_ee_wage_limit,
575: ti.sui_er_wage_limit
576: FROM PAY_US_STATES st,
577: PAY_US_STATE_TAX_INFO_F ti
578: WHERE v_effective_date BETWEEN
579: ti.effective_start_date AND ti.effective_end_date
580: and st.state_code =

Line 1268: FROM PAY_US_STATES

1264: c_proc VARCHAR2(100) := 'derive_jd_geocode';
1265:
1266: CURSOR csr_state_code IS
1267: SELECT state_code
1268: FROM PAY_US_STATES
1269: WHERE state_abbrev = p_state_abbrev
1270: ;
1271:
1272: CURSOR csr_county_code IS

Line 1276: PAY_US_STATES s

1272: CURSOR csr_county_code IS
1273: SELECT cn.state_code,
1274: cn.county_code
1275: FROM PAY_US_COUNTIES cn,
1276: PAY_US_STATES s
1277: WHERE cn.county_name = p_county_name
1278: and cn.state_code = s.state_code
1279: and s.state_abbrev = p_state_abbrev
1280: ;

Line 1288: PAY_US_STATES pus

1284: -- the employee's assignment
1285: CURSOR csr_chk_state IS
1286: SELECT 'PASS'
1287: FROM PAY_US_EMP_STATE_TAX_RULES st,
1288: PAY_US_STATES pus
1289: WHERE st.assignment_id = p_assignment_id
1290: and st.state_code = pus.state_code
1291: and pus.state_abbrev = p_state_abbrev
1292: ;

Line 1593: pay_us_states pus

1589: pus.state_abbrev
1590: FROM PAY_US_EMP_FED_TAX_RULES_F fed,
1591: PER_ASSIGNMENTS_F a,
1592: PER_BUSINESS_GROUPS bg,
1593: pay_us_states pus
1594: WHERE fed.assignment_id = a.assignment_id
1595: and a.assignment_number = p_assignment_number
1596: and a.business_group_id = bg.business_group_id
1597: and bg.name ||'' = p_business_group_name