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_GET_TAX_EXISTS_PKG dependencies on PER_ADDRESSES

Line 172: per_addresses pa,

168: CURSOR c_override_state_county IS
169: SELECT puc.state_code || '-' || puc.county_code
170: FROM pay_us_counties puc,
171: pay_us_states pus,
172: per_addresses pa,
173: per_assignments_f paf
174: WHERE paf.assignment_id = p_assign_id
175: AND paf.person_id = pa.person_id
176: AND pa.primary_flag = 'Y'

Line 219: per_addresses pa,

215: pa.date_from
216: INTO l_rs_county_code, l_res_adr_date_start
217: FROM pay_us_counties puc,
218: pay_us_states pus,
219: per_addresses pa,
220: per_assignments_f paf
221: WHERE paf.assignment_id = p_assign_id
222: AND paf.person_id = pa.person_id
223: AND pa.primary_flag = 'Y'

Line 709: per_addresses ADDR,

705:
706: cursor override_state is
707: select nvl(ADDR.add_information17,'ZZ')
708: from
709: per_addresses ADDR,
710: per_all_assignments_f ASSIGN
711: where TO_DATE(l_date_earned, 'dd-mm-yyyy')
712: between ASSIGN.effective_start_date
713: and ASSIGN.effective_end_date

Line 2139: FROM per_addresses addr,

2135: l_county_rs_exists varchar2(2);
2136:
2137: CURSOR override_state IS
2138: SELECT NVL(addr.add_information17,'ZZ')
2139: FROM per_addresses addr,
2140: per_all_assignments_f asg
2141: WHERE TO_DATE(l_date_earned, 'dd-mm-yyyy')
2142: BETWEEN asg.effective_start_date
2143: AND asg.effective_end_date