DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_US_EMP_COUNTY_TAX_RULES

Line 2081: FROM PAY_US_EMP_COUNTY_TAX_RULES

2077: WHERE assignment_id = p_assignment_id
2078: and jurisdiction_code = x_jd
2079: UNION
2080: SELECT 'PASS'
2081: FROM PAY_US_EMP_COUNTY_TAX_RULES
2082: WHERE assignment_id = p_assignment_id
2083: and jurisdiction_code = x_jd
2084: ;
2085:

Line 2714: FROM pay_us_emp_county_tax_rules_f cnt,

2710: CURSOR csr_county_exempt (cp_jurisdiction_code IN VARCHAR2)
2711: IS
2712: SELECT cnt.lit_exempt,
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