73: select distinct acct_role.cust_account_role_id contact_id
74: from hz_cust_account_roles acct_role,
75: hz_parties party,
76: hz_relationships rel,
77: hz_org_contacts org_cont,
78: hz_parties rel_party
79: where acct_role.party_id = rel.party_id
80: and acct_role.role_type = 'CONTACT'
81: and org_cont.party_relationship_id = rel.relationship_id
97: select distinct acct_role.cust_account_role_id contact_id
98: from hz_cust_account_roles acct_role,
99: hz_parties party,
100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,
103: hz_cust_acct_sites acct_site,
104: hz_cust_site_uses site_uses
105: where acct_role.party_id = rel.party_id
793: INTO l_selected_id
794: from hz_cust_account_roles acct_role,
795: hz_parties party,
796: hz_relationships rel,
797: hz_org_contacts org_cont,
798: hz_parties rel_party
799: where acct_role.party_id = rel.party_id
800: and acct_role.role_type = 'CONTACT'
801: and org_cont.party_relationship_id =
2101: INTO l_dummy
2102: from hz_cust_account_roles acct_role,
2103: hz_parties party,
2104: hz_relationships rel,
2105: hz_org_contacts org_cont,
2106: hz_parties rel_party
2107: where acct_role.party_id = rel.party_id
2108: and acct_role.role_type = 'CONTACT'
2109: and org_cont.party_relationship_id =
2184: INTO l_dummy
2185: from hz_cust_account_roles acct_role,
2186: hz_parties party,
2187: hz_relationships rel,
2188: hz_org_contacts org_cont,
2189: hz_parties rel_party
2190: where acct_role.party_id = rel.party_id
2191: and acct_role.role_type = 'CONTACT'
2192: and org_cont.party_relationship_id =