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.PER_ZA_WSP_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1996: From hr_all_organization_units haou

1992: , hoi.org_information1 tel_no -- A(1).5 Telephone number
1993: , hoi.org_information2 fax_no -- A(1).6 Fax number
1994: , hoi.org_information3 email_add -- A(1).7 E-mail Address
1995: , hoi1.org_information12 sdl_no
1996: From hr_all_organization_units haou
1997: , hr_organization_information hoi
1998: , hr_organization_information hoi1
1999: Where haou.business_group_id = g_bg_id
2000: and haou.organization_id = p_legal_entity_id

Line 2009: from hr_all_organization_units haou

2005:
2006: cursor csr_seta_info(p_legal_entity_id in number) is
2007: select hoi.org_information1 SETA_Name
2008: , hoi.org_information3 activity_name
2009: from hr_all_organization_units haou
2010: , hr_organization_information hoi
2011: where haou.business_group_id = g_bg_id
2012: and haou.organization_id = p_legal_entity_id
2013: and haou.organization_id = hoi.organization_id

Line 2045: from hr_all_organization_units haou

2041: , hoi.org_information9 sdf_telephone_no
2042: , hoi.org_information10 sdf_fax_no
2043: , hoi.org_information11 sdf_email_id
2044: , hoi.org_information12 sdf_mobile_no
2045: from hr_all_organization_units haou
2046: , hr_organization_information hoi
2047: where haou.business_group_id = g_bg_id
2048: and haou.organization_id = p_legal_entity_id
2049: and haou.organization_id = hoi.organization_id