APPS.RRS_IMPORT_INTERFACE_PKG dependencies on HZ_ORGANIZATION_PROFILES

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'