APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1997: , hr_organization_information hoi

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
2001: and haou.organization_id = hoi1.organization_id

Line 1998: , hr_organization_information hoi1

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
2001: and haou.organization_id = hoi1.organization_id
2002: and hoi.org_information_context(+) = 'ZA_LEGAL_ENTITY_CONTACT_INFO'

Line 2010: , hr_organization_information hoi

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
2014: and hoi.org_information_context = 'ZA_NQF_SETA_INFO';

Line 2046: , hr_organization_information hoi

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
2050: and hoi.org_information_context = 'ZA_SDF_INFO';