DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 2366: FROM pay_us_emp_state_tax_rules_f pes,

2362: l_eff_end_date IN DATE,
2363: l_ar_state_abbrev IN VARCHAR2)
2364: IS
2365: SELECT pus.state_abbrev
2366: FROM pay_us_emp_state_tax_rules_f pes,
2367: pay_us_states pus
2368: WHERE pes.state_code = pus.state_code
2369: AND pus.state_abbrev <> l_ar_state_abbrev
2370: AND pes.effective_start_date <= l_eff_end_date