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

Line 214: FROM per_addresses

210: SELECT address_id,
211: date_from,
212: date_to,
213: object_version_number
214: FROM per_addresses
215: WHERE person_id = cp_person_id
216: AND cp_effective_date BETWEEN date_from
217: AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'))
218: AND primary_flag = 'Y'

Line 1172: from per_addresses addr,

1168: IS
1169: SELECT NVL(addr.add_information17,addr.region_2) state_abbrev,
1170: NVL(addr.add_information19,addr.region_1) county_name,
1171: NVL(addr.add_information18,addr.town_or_city) city_name
1172: from per_addresses addr,
1173: per_all_assignments_f asg
1174: WHERE cp_effective_date BETWEEN asg.effective_start_date
1175: AND asg.effective_end_date
1176: AND asg.assignment_id = cp_assignment_id

Line 2234: FROM per_addresses pa

2230: ,cp_effective_date DATE
2231: ,cp_legislation_code VARCHAR2)
2232: IS
2233: SELECT pus.state_code || '-000-0000'
2234: FROM per_addresses pa
2235: ,pay_us_states pus
2236: WHERE pa.person_id = cp_person_id
2237: AND pa.primary_flag = 'Y'
2238: AND cp_effective_date BETWEEN pa.date_from