APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_RELATIONSHIPS

Line 1975: from hz_org_contacts org ,hz_relationships rel

1971:
1972: --//Table hz_org_contacts
1973: cursor c_org_cont_id is
1974: select rel.object_id
1975: from hz_org_contacts org ,hz_relationships rel
1976: where org.org_contact_id = p_owner_table_id
1977: and org.party_relationship_id = rel.relationship_id
1978: and rel.directional_flag = 'F';
1979: --and org.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'

Line 1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel

1980:
1981: --//Table hz_org_contact_roles
1982: cursor c_org_cont_role_id is
1983: select rel.object_id
1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel
1985: where roles.org_contact_role_id = p_owner_table_id
1986: and roles.org_contact_id = org.org_contact_id
1987: and org.party_relationship_id = rel.relationship_id
1988: and rel.directional_flag = 'F';