DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on HZ_ORG_CONTACTS

Line 738: FROM hz_org_contacts org_con

734: AND rel.subject_table_name = 'HZ_PARTIES'
735: AND rel.object_table_name = 'HZ_PARTIES'
736: AND rel.relationship_id IN
737: (SELECT party_relationship_id
738: FROM hz_org_contacts org_con
739: WHERE rel.relationship_id =
740: org_con.party_relationship_id
741: AND org_con.status ='A' )
742: AND party5.party_id = l_customer_id