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.

[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on HR_LOCATIONS

Line 3646: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is

3642:
3643: l_inv_code VARCHAR2(50); -- BUG 6785691
3644:
3645: -- bug# 6989166 starts
3646: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
3647: Select ship_to_location_id
3648: From hr_locations
3649: Where location_code = p_ship_to_loc_code
3650: and nvl(ship_to_site_flag, 'N') = 'Y';

Line 3648: From hr_locations

3644:
3645: -- bug# 6989166 starts
3646: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
3647: Select ship_to_location_id
3648: From hr_locations
3649: Where location_code = p_ship_to_loc_code
3650: and nvl(ship_to_site_flag, 'N') = 'Y';
3651: -- bug# 6989166 ends
3652: