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 712: per_addresses ADDR,

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

Line 2142: FROM per_addresses addr,

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