APPS.AR_INVOICE_UTILS dependencies on HZ_ORG_CONTACTS

Line 787: hz_org_contacts org_cont,

783: (SELECT 'X'
784: FROM hz_cust_account_roles acct_role,
785: hz_parties party,
786: hz_relationships rel,
787: hz_org_contacts org_cont,
788: hz_parties rel_party
789: WHERE acct_role.party_id = rel.party_id
790: AND acct_role.role_type = 'CONTACT'
791: and org_cont.party_relationship_id = rel.relationship_id

Line 842: hz_org_contacts org_cont,

838: (SELECT 'X'
839: FROM hz_cust_account_roles acct_role,
840: hz_parties party,
841: hz_relationships rel,
842: hz_org_contacts org_cont,
843: hz_parties rel_party
844: WHERE acct_role.party_id = rel.party_id
845: AND acct_role.role_type = 'CONTACT'
846: and org_cont.party_relationship_id = rel.relationship_id

Line 3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY

3297: BEGIN
3298: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3299: INTO l_contact_id
3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3302: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3303: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3305: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY

3496: BEGIN
3497: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3498: INTO l_contact_id
3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3501: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3502: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3504: AND REL.SUBJECT_ID = PARTY.PARTY_ID