DBA Data[Home] [Help]

APPS.CAC_VIEW_WF_PVT dependencies on HZ_RELATIONSHIPS

Line 29: hz_relationships hr,

25:
26: CURSOR c_contact_detail (b_resource_id NUMBER ) IS
27: select pers.PARTY_name , hc.email_ADDRESS
28: from hz_parties pers,
29: hz_relationships hr,
30: hz_contact_points hc
31: where hc.owner_table_id = b_resource_id
32: and hr.party_id = hc.owner_table_id
33: and hr.subject_id = pers.party_id