APPS.IEM_GETCUST_PVT dependencies on HZ_RELATIONSHIPS

Line 127: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr

123: ELSIF l_rec_tbl2.count>0 THEN
124: FOR j in l_rec_tbl2.FIRST..l_rec_tbl2.LAST LOOP
125:
126: select count(hzr.party_id) into l_v1count
127: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr
128: where hzp.party_type='PARTY_RELATIONSHIP'
129: and hzr.party_id=hzp.party_id
130: and hzr.party_id=l_rec_tbl2(j).owner_table_id
131: and hzr.status in('A','I')