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_ARCHIVE dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 3635: pay_us_emp_city_tax_rules_f pcty,

3631:
3632: cursor c_get_city is
3633: select distinct pcty.jurisdiction_code pcty
3634: from pay_us_city_tax_info_f cti,
3635: pay_us_emp_city_tax_rules_f pcty,
3636: per_all_assignments_f paf1
3637: where paf1.person_id = l_person_id
3638: and paf1.effective_end_date >= l_year_start
3639: and paf1.effective_start_date <= l_year_end

Line 3730: from pay_us_emp_city_tax_rules_f pcty,

3726: cursor c_get_cty_sd is
3727: select distinct pcty.state_code || '-'|| pcty.school_district_code,
3728: county_code,
3729: city_code
3730: from pay_us_emp_city_tax_rules_f pcty,
3731: per_all_assignments_f paf1
3732: where paf1.person_id = l_person_id
3733: and paf1.effective_end_date >= l_year_start
3734: and paf1.effective_start_date <= l_year_end