APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_ORG_CONTACTS

Line 77: hz_org_contacts org_cont,

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

Line 101: hz_org_contacts org_cont,

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

Line 795: hz_org_contacts org_cont,

791: INTO l_selected_id
792: from hz_cust_account_roles acct_role,
793: hz_parties party,
794: hz_relationships rel,
795: hz_org_contacts org_cont,
796: hz_parties rel_party
797: where acct_role.party_id = rel.party_id
798: and acct_role.role_type = 'CONTACT'
799: and org_cont.party_relationship_id =

Line 2081: hz_org_contacts org_cont,

2077: INTO l_dummy
2078: from hz_cust_account_roles acct_role,
2079: hz_parties party,
2080: hz_relationships rel,
2081: hz_org_contacts org_cont,
2082: hz_parties rel_party
2083: where acct_role.party_id = rel.party_id
2084: and acct_role.role_type = 'CONTACT'
2085: and org_cont.party_relationship_id =

Line 2164: hz_org_contacts org_cont,

2160: INTO l_dummy
2161: from hz_cust_account_roles acct_role,
2162: hz_parties party,
2163: hz_relationships rel,
2164: hz_org_contacts org_cont,
2165: hz_parties rel_party
2166: where acct_role.party_id = rel.party_id
2167: and acct_role.role_type = 'CONTACT'
2168: and org_cont.party_relationship_id =