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

Line 83: FROM hr_organization_information hoi,

79: SELECT 'Y'
80: FROM pay_payroll_actions ppa
81: WHERE ppa.action_type = 'L'
82: AND EXISTS ( SELECT 'Y'
83: FROM hr_organization_information hoi,
84: hr_all_organization_units hou
85: WHERE hoi.org_information_context = 'Business Group Information'
86: AND hou.organization_id = hoi.organization_id
87: AND hoi.org_information9 = UPPER(p_legislation_code)

Line 96: FROM hr_organization_information hoi

92: SELECT 'Y'
93: FROM pay_payroll_actions ppa
94: WHERE ppa.action_type = 'L'
95: AND EXISTS ( SELECT 'Y'
96: FROM hr_organization_information hoi
97: WHERE hoi.org_information_context = 'Business Group Information'
98: AND hoi.org_information9 = UPPER(p_legislation_code)
99: AND hoi.organization_id = ppa.business_group_id)
100: AND ROWNUM < 2;*/

Line 105: hr_organization_information hoi

101: CURSOR c_get_legislative_bg(p_legislation_code IN VARCHAR2)
102: IS
103: SELECT business_group_id
104: FROM per_business_groups pbg,
105: hr_organization_information hoi
106: WHERE hoi.organization_id = pbg.business_group_id
107: AND hoi.org_information_context = 'Business Group Information'
108: AND hoi.org_information9 = UPPER(p_legislation_code);
109: