DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on HZ_RELATIONSHIPS

Line 5135: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id

5131: RETURN VARCHAR2
5132: IS
5133: CURSOR C1 IS
5134: select HP.party_id,HP.party_name
5135: from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
5136: and HPR.subject_type = 'PERSON'
5137: and HPR.object_type = 'ORGANIZATION'
5138: and hp.party_id=HPR.subject_id;
5139: CURSOR C2 IS