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.

APPS.PAY_US_ARCHIVE dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 3068: from pay_us_emp_county_tax_rules_f pcnt,

3064: for the person_id corresponding to the assignment_id */
3065: /*
3066: cursor c_get_county is
3067: select distinct pcnt.jurisdiction_code
3068: from pay_us_emp_county_tax_rules_f pcnt,
3069: per_all_assignments_f paf1
3070: where paf1.person_id = l_person_id
3071: and paf1.effective_end_date >= l_year_start
3072: and paf1.effective_start_date <= l_year_end

Line 3081: pay_us_emp_county_tax_rules_f pcnt,

3077:
3078: cursor c_get_county is
3079: select distinct pcnt.jurisdiction_code
3080: from pay_us_county_tax_info_f cnti,
3081: pay_us_emp_county_tax_rules_f pcnt,
3082: per_all_assignments_f paf1
3083: where paf1.person_id = l_person_id
3084: and paf1.effective_end_date >= l_year_start
3085: and paf1.effective_start_date <= l_year_end

Line 3129: from pay_us_emp_county_tax_rules_f pcnt,

3125:
3126: cursor c_get_cnt_sd is
3127: select distinct pcnt.state_code || '-'|| pcnt.school_district_code,
3128: pcnt.county_code
3129: from pay_us_emp_county_tax_rules_f pcnt,
3130: per_all_assignments_f paf1
3131: where paf1.person_id = l_person_id
3132: and paf1.effective_end_date >= l_year_start
3133: and paf1.effective_start_date <= l_year_end