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_TAX_BALS_ADJ_API dependencies on HR_LOCATIONS

Line 2556: FROM HR_LOCATIONS loc,

2552:
2553: CURSOR csr_sdi_check IS
2554:
2555: /* SELECT region_2 primary_asg_state
2556: FROM HR_LOCATIONS loc,
2557: PER_ASSIGNMENTS_F asg,
2558: PER_BUSINESS_GROUPS bg
2559: -- Bug fix 1398865. Ensures one row is returned
2560: WHERE asg.assignment_number = p_assignment_number

Line 2572: FROM HR_LOCATIONS loc,

2568: */
2569: SELECT decode(nvl(asg.work_at_home, 'N'),
2570: 'N' , loc.region_2,
2571: addr.region_2) primary_asg_state
2572: FROM HR_LOCATIONS loc,
2573: PER_ASSIGNMENTS_F asg,
2574: PER_BUSINESS_GROUPS bg,
2575: PER_ADDRESSES addr
2576: -- Bug fix 1398865. Ensures one row is returned

Line 2962: FROM hr_locations HRLOC

2958: INTO l_loc_state_abbrev,
2959: l_loc_county,
2960: l_loc_city,
2961: l_loc_zip_code
2962: FROM hr_locations HRLOC
2963: , hr_soft_coding_keyflex HRSCKF
2964: , per_all_assignments_f ASSIGN
2965: , pay_us_states PUS
2966: where p_adjustment_date BETWEEN ASSIGN.effective_start_date