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_GEOCODE_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 4200: hr_organization_information hoi,

4196: NVL(hoit.displayed_org_information_type,fdfv.descriptive_flex_context_name)||
4197: ', '||fdfc.form_left_prompt
4198: from pay_patch_status pps,
4199: pay_us_geo_update pgu,
4200: hr_organization_information hoi,
4201: hr_organization_units hou,
4202: fnd_descr_flex_contexts_vl fdfv,
4203: fnd_descr_flex_col_usage_vl fdfc,
4204: hr_org_information_types hoit,

Line 4208: and pgu.table_name = 'HR_ORGANIZATION_INFORMATION'

4204: hr_org_information_types hoit,
4205: pay_us_modified_geocodes pumg1,
4206: pay_us_modified_geocodes pumg2
4207: where pgu.process_type = 'CY'
4208: and pgu.table_name = 'HR_ORGANIZATION_INFORMATION'
4209: and hoi.org_information_id = pgu.table_value_id
4210: and hoi.organization_id = hou.organization_id
4211: and hoi.org_information_context = substr(pgu.description,1,instr(pgu.description,':')-1)
4212: and hoi.org_information_context = fdfv.descriptive_flex_context_code