APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_PARTY_SITE_USES

Line 147: Hz_Party_Site_uses hpsu,

143: Begin
144: SELECT hpsu.party_site_use_id
145: INTO l_party_site_use_id
146: FROM Hz_Party_Sites hps,
147: Hz_Party_Site_uses hpsu,
148: Hz_Locations hl
149: WHERE hps.party_site_id = l_party_site_id
150: AND hpsu.site_use_type = p_site_use_type
151: AND hps.status = 'A'

Line 262: from hz_party_site_uses

258: l_msg_index_out NUMBER;
259:
260: CURSOR c_party_site_id(p_party_site_use_id in number) IS
261: select party_site_id
262: from hz_party_site_uses
263: where party_site_use_id = p_party_site_use_id;
264:
265: CURSOR c_party_id(p_party_site_id in number) IS
266: select party_id