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.PQP_UK_UNION_DEDUCTION dependencies on HR_ORGANIZATION_INFORMATION

Line 181: FROM hr_organization_information hoi

177: , TO_CHAR(fnds.effective_date,'YYYY') -- use current year
178: -- Recalculation month >= than current month
179: ,TO_CHAR(fnds.effective_date-365,'YYYY') -- use previous year
180: )
181: FROM hr_organization_information hoi
182: ,pay_user_tables tbls
183: ,fnd_sessions fnds
184: WHERE hoi.organization_id = p_union_organization_id
185: AND hoi.org_information_context = g_union_org_info_type

Line 280: FROM hr_organization_information hoi

276: -- Recalculation month >= than current month
277: ,TO_CHAR(fnds.effective_date-365,'YYYY') -- use previous year
278: )
279: ||'/'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'MM/DD')
280: FROM hr_organization_information hoi
281: ,pay_user_tables tbls
282: ,fnd_sessions fnds
283: WHERE hoi.organization_id = p_union_organization_id
284: AND hoi.org_information_context = g_union_org_info_type