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 1994: From hr_all_organization_units haou

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

Line 2007: from hr_all_organization_units haou

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

Line 2043: from hr_all_organization_units haou

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