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

Line 2243: FROM per_addresses pa

2239:
2240: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
2241: ,cp_bg_id IN NUMBER) IS
2242: SELECT pus.state_code || '-000-0000'
2243: FROM per_addresses pa
2244: ,pay_us_states pus
2245: WHERE pa.person_id = cp_person_id
2246: AND pa.primary_flag = 'Y'
2247: AND p_curr_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

Line 4906: FROM per_addresses pa

4902:
4903: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
4904: ,cp_bg_id IN NUMBER) IS
4905: SELECT pus.state_code || '-000-0000'
4906: FROM per_addresses pa
4907: ,pay_us_states pus
4908: WHERE pa.person_id = cp_person_id
4909: AND pa.primary_flag = 'Y'
4910: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

Line 5478: FROM per_addresses pa

5474:
5475: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
5476: ,cp_bg_id IN NUMBER) IS
5477: SELECT pus.state_code || '-000-0000'
5478: FROM per_addresses pa
5479: ,pay_us_states pus
5480: WHERE pa.person_id = cp_person_id
5481: AND pa.primary_flag = 'Y'
5482: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

Line 6079: FROM per_addresses pa

6075:
6076: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
6077: ,cp_bg_id IN NUMBER) IS
6078: SELECT pus.state_code || '-000-0000'
6079: FROM per_addresses pa
6080: ,pay_us_states pus
6081: WHERE pa.person_id = cp_person_id
6082: AND pa.primary_flag = 'Y'
6083: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)