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_COUNTY_TAX_RULES_F

Line 3655: from pay_us_emp_county_tax_rules_f pcnt,

3651: for the person_id corresponding to the assignment_id */
3652: /*
3653: cursor c_get_county is
3654: select distinct pcnt.jurisdiction_code
3655: from pay_us_emp_county_tax_rules_f pcnt,
3656: per_all_assignments_f paf1
3657: where paf1.person_id = l_person_id
3658: and paf1.effective_end_date >= l_year_start
3659: and paf1.effective_start_date <= l_year_end

Line 3668: pay_us_emp_county_tax_rules_f pcnt,

3664:
3665: cursor c_get_county is
3666: select distinct pcnt.jurisdiction_code
3667: from pay_us_county_tax_info_f cnti,
3668: pay_us_emp_county_tax_rules_f pcnt,
3669: per_all_assignments_f paf1
3670: where paf1.person_id = l_person_id
3671: and paf1.effective_end_date >= l_year_start
3672: and paf1.effective_start_date <= l_year_end

Line 3716: from pay_us_emp_county_tax_rules_f pcnt,

3712:
3713: cursor c_get_cnt_sd is
3714: select distinct pcnt.state_code || '-'|| pcnt.school_district_code,
3715: pcnt.county_code
3716: from pay_us_emp_county_tax_rules_f pcnt,
3717: per_all_assignments_f paf1
3718: where paf1.person_id = l_person_id
3719: and paf1.effective_end_date >= l_year_start
3720: and paf1.effective_start_date <= l_year_end