APPS.AR_INVOICE_UTILS dependencies on HZ_ORG_CONTACTS

Line 794: hz_org_contacts org_cont,

790: (SELECT 'X'
791: FROM hz_cust_account_roles acct_role,
792: hz_parties party,
793: hz_relationships rel,
794: hz_org_contacts org_cont,
795: hz_parties rel_party
796: WHERE acct_role.party_id = rel.party_id
797: AND acct_role.role_type = 'CONTACT'
798: and org_cont.party_relationship_id = rel.relationship_id

Line 849: hz_org_contacts org_cont,

845: (SELECT 'X'
846: FROM hz_cust_account_roles acct_role,
847: hz_parties party,
848: hz_relationships rel,
849: hz_org_contacts org_cont,
850: hz_parties rel_party
851: WHERE acct_role.party_id = rel.party_id
852: AND acct_role.role_type = 'CONTACT'
853: and org_cont.party_relationship_id = rel.relationship_id

Line 3396: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY

3392: BEGIN
3393: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3394: INTO l_contact_id
3395: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3396: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3397: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3398: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3399: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3400: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 3595: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY

3591: BEGIN
3592: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3593: INTO l_contact_id
3594: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3595: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3596: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3597: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3598: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3599: AND REL.SUBJECT_ID = PARTY.PARTY_ID