APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_EMP_CITY_TAX_RULES

Line 2076: FROM PAY_US_EMP_CITY_TAX_RULES

2072: ;
2073:
2074: CURSOR csr_chk_local (x_jd VARCHAR2) IS
2075: SELECT 'PASS'
2076: FROM PAY_US_EMP_CITY_TAX_RULES
2077: WHERE assignment_id = p_assignment_id
2078: and jurisdiction_code = x_jd
2079: UNION
2080: SELECT 'PASS'

Line 2733: FROM pay_us_emp_city_tax_rules_f cty,

2729: CURSOR csr_city_exempt (cp_jurisdiction_code IN VARCHAR2)
2730: IS
2731: SELECT cty.lit_exempt,
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