DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_EMP_COUNTY_TAX_RULES

Line 1716: FROM PAY_US_EMP_COUNTY_TAX_RULES

1712: WHERE assignment_id = p_assignment_id
1713: and jurisdiction_code = x_jd
1714: UNION
1715: SELECT 'PASS'
1716: FROM PAY_US_EMP_COUNTY_TAX_RULES
1717: WHERE assignment_id = p_assignment_id
1718: and jurisdiction_code = x_jd
1719: ;
1720:

Line 2163: FROM pay_us_emp_county_tax_rules_f cnt,

2159: CURSOR csr_county_exempt (cp_jurisdiction_code IN VARCHAR2)
2160: IS
2161: SELECT cnt.lit_exempt,
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