APPS.RRS_IMPORT_INTERFACE_PKG dependencies on HZ_PARTIES

Line 1985: FROM HZ_PARTIES HP, HZ_ORGANIZATION_PROFILES HOP

1981:
1982: Begin
1983: SELECT HP.PARTY_ID
1984: into l_site_party_id
1985: FROM HZ_PARTIES HP, HZ_ORGANIZATION_PROFILES HOP
1986: WHERE HP.PARTY_ID = HOP.PARTY_ID
1987: AND HP.PARTY_ID = p_site_party_id
1988: AND NVL(HOP.INTERNAL_FLAG,'N') = 'N'
1989: AND HP.PARTY_TYPE = 'ORGANIZATION'

Line 2020: hz_parties hp,

2016: xle_registrations xr,
2017: xle_jurisdictions_vl jur,
2018: hr_locations hl,
2019: hz_geographies b,
2020: hz_parties hp,
2021: xle_lookups l,
2022: xle_lookups l1
2023: WHERE l.lookup_type = 'XLE_YES_NO'
2024: AND l.lookup_code = xep.transacting_entity_flag