APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_EMP_CITY_TAX_RULES

Line 1711: FROM PAY_US_EMP_CITY_TAX_RULES

1707: ;
1708:
1709: CURSOR csr_chk_local (x_jd VARCHAR2) IS
1710: SELECT 'PASS'
1711: FROM PAY_US_EMP_CITY_TAX_RULES
1712: WHERE assignment_id = p_assignment_id
1713: and jurisdiction_code = x_jd
1714: UNION
1715: SELECT 'PASS'

Line 2182: FROM pay_us_emp_city_tax_rules_f cty,

2178: CURSOR csr_city_exempt (cp_jurisdiction_code IN VARCHAR2)
2179: IS
2180: SELECT cty.lit_exempt,
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