APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1995: , hr_organization_information hoi

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

Line 1996: , hr_organization_information hoi1

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

Line 2008: , hr_organization_information hoi

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

Line 2044: , hr_organization_information hoi

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