APPS.IEM_GETCUST_PVT dependencies on HZ_RELATIONSHIPS

Line 140: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr

136: ELSIF l_rec_tbl2.count>0 THEN
137: FOR j in l_rec_tbl2.FIRST..l_rec_tbl2.LAST LOOP
138:
139: select count(hzr.party_id) into l_v1count
140: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr
141: where hzp.party_type='PARTY_RELATIONSHIP'
142: and hzr.party_id=hzp.party_id
143: and hzr.party_id=l_rec_tbl2(j).owner_table_id
144: and hzr.status in('A','I')