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 PAY_US_STATES

Line 1887: ,pay_us_states pus

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)
1891: AND pa.business_group_id = cp_bg_id

Line 2330: pay_us_states pus,

2326: || '-'
2327: || punc.city_code jurisdiction_code
2328: FROM per_all_assignments_f peaf,
2329: hr_locations_all hla,
2330: pay_us_states pus,
2331: pay_us_counties puc,
2332: pay_us_city_names punc,
2333: pay_assignment_actions paa,
2334: pay_payroll_actions ppa

Line 4356: ,pay_us_states pus

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)
4360: AND pa.business_group_id = cp_bg_id

Line 4523: pay_us_states pus,

4519: || '-'
4520: || punc.city_code jurisdiction_code
4521: FROM per_all_assignments_f peaf,
4522: hr_locations_all hla,
4523: pay_us_states pus,
4524: pay_us_counties puc,
4525: pay_us_city_names punc,
4526: pay_assignment_actions paa,
4527: pay_payroll_actions ppa

Line 4858: ,pay_us_states pus

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)
4862: AND pa.business_group_id = cp_bg_id

Line 5058: pay_us_states pus,

5054: || '-'
5055: || punc.city_code jurisdiction_code
5056: FROM per_all_assignments_f peaf,
5057: hr_locations_all hla,
5058: pay_us_states pus,
5059: pay_us_counties puc,
5060: pay_us_city_names punc,
5061: pay_assignment_actions paa,
5062: pay_payroll_actions ppa