DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on HZ_RELATIONSHIPS

Line 702: hz_relationships hr

698: hr.status relationship_status,
699: hr.start_date start_date,
700: hr.end_date end_date
701: FROM hz_parties hz,
702: hz_relationships hr
703: WHERE hr.object_id = p_party_id -- The party being passsed
704: AND hz.party_id = p_contact_id -- The contact id
705: AND hr.object_type = 'ORGANIZATION'
706: AND hr.object_table_name = 'HZ_PARTIES'