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

Line 7602: hr_organization_information hoi1,

7598: , NVL (TRIM (RPAD (hoi3.ORG_INFORMATION2, 30)), ' ') -- 12556436 EMAIL ADDRESS
7599: FROM hr_all_organization_units hou,
7600: hr_locations hl,
7601: pay_payroll_actions ppa,
7602: hr_organization_information hoi1,
7603: hr_organization_information hoi2
7604: ,hr_organization_information hoi3 --12556436
7605: WHERE ppa.payroll_action_id = p_payroll_action_id
7606: AND hou.business_group_id = ppa.business_group_id

Line 7603: hr_organization_information hoi2

7599: FROM hr_all_organization_units hou,
7600: hr_locations hl,
7601: pay_payroll_actions ppa,
7602: hr_organization_information hoi1,
7603: hr_organization_information hoi2
7604: ,hr_organization_information hoi3 --12556436
7605: WHERE ppa.payroll_action_id = p_payroll_action_id
7606: AND hou.business_group_id = ppa.business_group_id
7607: AND hou.organization_id = pay_ie_p35.get_parameter (ppa.payroll_action_id, 'EMP_NO')

Line 7604: ,hr_organization_information hoi3 --12556436

7600: hr_locations hl,
7601: pay_payroll_actions ppa,
7602: hr_organization_information hoi1,
7603: hr_organization_information hoi2
7604: ,hr_organization_information hoi3 --12556436
7605: WHERE ppa.payroll_action_id = p_payroll_action_id
7606: AND hou.business_group_id = ppa.business_group_id
7607: AND hou.organization_id = pay_ie_p35.get_parameter (ppa.payroll_action_id, 'EMP_NO')
7608: AND hl.location_id(+) = hou.location_id