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 2244: ,pay_us_states pus

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

Line 2810: pay_us_states pus,

2806: || '-'
2807: || punc.city_code jurisdiction_code
2808: FROM per_all_assignments_f peaf,
2809: hr_locations_all hla,
2810: pay_us_states pus,
2811: pay_us_counties puc,
2812: pay_us_city_names punc,
2813: pay_assignment_actions paa,
2814: pay_payroll_actions ppa

Line 4907: ,pay_us_states pus

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

Line 5126: pay_us_states pus,

5122: || '-'
5123: || punc.city_code jurisdiction_code
5124: FROM per_all_assignments_f peaf,
5125: hr_locations_all hla,
5126: pay_us_states pus,
5127: pay_us_counties puc,
5128: pay_us_city_names punc,
5129: pay_assignment_actions paa,
5130: pay_payroll_actions ppa

Line 5479: ,pay_us_states pus

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

Line 5681: pay_us_states pus,

5677: || '-'
5678: || punc.city_code jurisdiction_code
5679: FROM per_all_assignments_f peaf,
5680: hr_locations_all hla,
5681: pay_us_states pus,
5682: pay_us_counties puc,
5683: pay_us_city_names punc,
5684: pay_assignment_actions paa,
5685: pay_payroll_actions ppa

Line 6080: ,pay_us_states pus

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

Line 6293: pay_us_states pus,

6289: || '-'
6290: || punc.city_code jurisdiction_code
6291: FROM per_all_assignments_f peaf,
6292: hr_locations_all hla,
6293: pay_us_states pus,
6294: pay_us_counties puc,
6295: pay_us_city_names punc,
6296: pay_assignment_actions paa,
6297: pay_payroll_actions ppa