eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 2338: FROM pay_us_emp_fed_tax_rules_f pef,

2334: l_eff_end_date IN DATE,
2335: l_ar_state_abbrev IN VARCHAR2)
2336: IS
2337: SELECT pus.state_abbrev
2338: FROM pay_us_emp_fed_tax_rules_f pef,
2339: pay_us_states pus
2340: WHERE pef.sui_state_code = pus.state_code
2341: AND pus.state_abbrev <> l_ar_state_abbrev
2342: AND pef.effective_start_date <= l_eff_end_date

Line 2606: pay_us_emp_fed_tax_rules_f pef,

2602:
2603: SELECT LEAST(MAX(pef.effective_end_date), p_effective_date)
2604: INTO l_effective_date
2605: FROM per_all_assignments_f paa,
2606: pay_us_emp_fed_tax_rules_f pef,
2607: pay_us_states pus
2608: WHERE paa.assignment_id = pef.assignment_id
2609: AND paa.assignment_id = asgid
2610: AND paa.assignment_type = 'E'