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 1886: FROM per_addresses pa

1882:
1883: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
1884: ,cp_bg_id IN NUMBER) IS
1885: SELECT pus.state_code || '-000-0000'
1886: FROM per_addresses pa
1887: ,pay_us_states pus
1888: WHERE pa.person_id = cp_person_id
1889: AND pa.primary_flag = 'Y'
1890: AND p_curr_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

Line 4355: FROM per_addresses pa

4351:
4352: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
4353: ,cp_bg_id IN NUMBER) IS
4354: SELECT pus.state_code || '-000-0000'
4355: FROM per_addresses pa
4356: ,pay_us_states pus
4357: WHERE pa.person_id = cp_person_id
4358: AND pa.primary_flag = 'Y'
4359: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

Line 4857: FROM per_addresses pa

4853:
4854: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER
4855: ,cp_bg_id IN NUMBER) IS
4856: SELECT pus.state_code || '-000-0000'
4857: FROM per_addresses pa
4858: ,pay_us_states pus
4859: WHERE pa.person_id = cp_person_id
4860: AND pa.primary_flag = 'Y'
4861: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)