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

Line 4989: FROM hr_organization_information

4985: --
4986: /*
4987: CURSOR csr_bus_grp IS
4988: SELECT org_information10
4989: FROM hr_organization_information
4990: WHERE organization_id = l_business_group_id;
4991: */
4992: -- cursor csr_bus_grp changed as the previous definition of it does not have
4993: -- the organization information context as a filter. Bug 5867046

Line 4996: FROM hr_organization_information hoi

4992: -- cursor csr_bus_grp changed as the previous definition of it does not have
4993: -- the organization information context as a filter. Bug 5867046
4994: CURSOR csr_bus_grp IS
4995: SELECT org_information10
4996: FROM hr_organization_information hoi
4997: WHERE hoi.organization_id = l_business_group_id
4998: AND hoi.org_information_context = 'Business Group Information'
4999: AND hoi.org_information2 IS NOT NULL
5000: AND EXISTS

Line 5003: hr_organization_information org_info

4999: AND hoi.org_information2 IS NOT NULL
5000: AND EXISTS
5001: ( SELECT NULL
5002: FROM hr_org_info_types_by_class oitbc,
5003: hr_organization_information org_info
5004: WHERE org_info.organization_id = hoi.organization_id
5005: AND org_info.org_information_context = 'CLASS'
5006: AND org_info.org_information2 = 'Y'
5007: AND oitbc.org_classification = org_info.org_information1