APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_STATES

Line 903: FROM PAY_US_STATES st,

899: ti.sdi_er_wage_limit,
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 =

Line 2048: FROM PAY_US_STATES

2044: c_proc VARCHAR2(100) := 'derive_jd_geocode';
2045:
2046: CURSOR csr_state_code IS
2047: SELECT state_code
2048: FROM PAY_US_STATES
2049: WHERE state_abbrev = p_state_abbrev
2050: ;
2051:
2052: CURSOR csr_county_code IS

Line 2056: PAY_US_STATES s

2052: CURSOR csr_county_code IS
2053: SELECT cn.state_code,
2054: cn.county_code
2055: FROM PAY_US_COUNTIES cn,
2056: PAY_US_STATES s
2057: WHERE cn.county_name = p_county_name
2058: and cn.state_code = s.state_code
2059: and s.state_abbrev = p_state_abbrev
2060: ;

Line 2068: PAY_US_STATES pus

2064: -- the employee's assignment
2065: CURSOR csr_chk_state IS
2066: SELECT 'PASS'
2067: FROM PAY_US_EMP_STATE_TAX_RULES st,
2068: PAY_US_STATES pus
2069: WHERE st.assignment_id = p_assignment_id
2070: and st.state_code = pus.state_code
2071: and pus.state_abbrev = p_state_abbrev
2072: ;

Line 2612: pay_us_states pus

2608: nvl(fed.FED_INFORMATION2,'N')
2609: FROM pay_us_emp_fed_tax_rules_f fed,
2610: PER_ASSIGNMENTS_F a,
2611: PER_BUSINESS_GROUPS bg,
2612: pay_us_states pus
2613: WHERE fed.assignment_id = a.assignment_id
2614: and a.assignment_number = p_assignment_number
2615: and a.business_group_id = bg.business_group_id
2616: and bg.name ||'' = p_business_group_name

Line 2698: pay_us_states pus

2694: sta.sui_exempt
2695: FROM pay_us_emp_state_tax_rules_f sta,
2696: PER_ASSIGNMENTS_F a,
2697: PER_BUSINESS_GROUPS bg,
2698: pay_us_states pus
2699: WHERE sta.assignment_id = a.assignment_id
2700: and a.assignment_number = p_assignment_number
2701: and a.business_group_id = bg.business_group_id
2702: and bg.name ||'' = p_business_group_name

Line 2717: pay_us_states pus

2713: NVL(cnt.sd_exempt,'N')
2714: FROM pay_us_emp_county_tax_rules_f cnt,
2715: PER_ASSIGNMENTS_F a,
2716: PER_BUSINESS_GROUPS bg,
2717: pay_us_states pus
2718: WHERE cnt.assignment_id = a.assignment_id
2719: and a.assignment_number = p_assignment_number
2720: and a.business_group_id = bg.business_group_id
2721: and bg.name ||'' = p_business_group_name

Line 2736: pay_us_states pus

2732: NVL(cty.sd_exempt,'N')
2733: FROM pay_us_emp_city_tax_rules_f cty,
2734: PER_ASSIGNMENTS_F a,
2735: PER_BUSINESS_GROUPS bg,
2736: pay_us_states pus
2737: WHERE cty.assignment_id = a.assignment_id
2738: and a.assignment_number = p_assignment_number
2739: and a.business_group_id = bg.business_group_id
2740: and bg.name ||'' = p_business_group_name

Line 2936: ,pay_us_states PUS

2932: l_per_city,
2933: l_per_zip_code
2934: FROM per_addresses ADDR
2935: ,per_all_assignments_f ASSIGN
2936: ,pay_us_states PUS
2937: where p_adjustment_date BETWEEN ASSIGN.effective_start_date
2938: AND ASSIGN.effective_end_date
2939: and ASSIGN.assignment_id = l_assignment_id
2940: and ADDR.person_id = ASSIGN.person_id

Line 2965: , pay_us_states PUS

2961: l_loc_zip_code
2962: FROM hr_locations HRLOC
2963: , hr_soft_coding_keyflex HRSCKF
2964: , per_all_assignments_f ASSIGN
2965: , pay_us_states PUS
2966: where p_adjustment_date BETWEEN ASSIGN.effective_start_date
2967: AND ASSIGN.effective_end_date
2968: and ASSIGN.assignment_id = l_assignment_id
2969: and ASSIGN.soft_coding_keyflex_id = HRSCKF.soft_coding_keyflex_id