APPS.ARP_CMERGE_ARCUS dependencies on HZ_RELATIONSHIPS

Line 2561: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel

2557: FOR UPDATE NOWAIT;
2558:
2559: CURSOR c3_1 is
2560: SELECT yt.party_id
2561: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel
2562: WHERE m.customer_id=ca.cust_account_id
2563: AND ((ca.status = 'A' and yt.cust_acct_site_id is not null) or (ca.status <> 'A'))
2564: AND m.duplicate_id = yt.cust_account_id
2565: AND rel.party_id = yt.party_id

Line 2578: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel

2574: -- End Bug No : 14201229
2575: ----Bug No: 5067291
2576: CURSOR c3 is
2577: SELECT yt.party_id
2578: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel
2579: WHERE m.customer_id=ca.cust_account_id
2580: AND m.duplicate_id = yt.cust_account_id
2581: AND rel.party_id = yt.party_id
2582: AND rel.subject_type = 'PERSON'

Line 3368: hz_relationships rel,

3364: -- FOR ORG-CONTACT REC
3365: org.org_contact_id
3366: FROM hz_cust_account_roles acct_role,
3367: hz_org_contacts org,
3368: hz_relationships rel,
3369: hz_cust_accounts acct
3370: WHERE acct_role.role_type = 'CONTACT'
3371: AND acct_role.cust_account_id = p_from_account_id
3372: AND acct_role.cust_acct_site_id IS NULL

Line 3527: hz_relationships rel,

3523: --merge context
3524: -- org.party_site_id
3525: FROM hz_cust_account_roles acct_role,
3526: hz_org_contacts org,
3527: hz_relationships rel,
3528: hz_cust_accounts acct
3529: WHERE acct_role.role_type = 'CONTACT'
3530: AND acct_role.cust_account_id = p_from_account_id
3531: AND acct_role.cust_acct_site_id = from_site_id

Line 3759: FROM hz_relationships

3755: END IF;
3756:
3757: IF l_dup_exists = FND_API.G_TRUE THEN
3758: SELECT party_id INTO x_org_party_id
3759: FROM hz_relationships
3760: WHERE relationship_id = (
3761: SELECT party_relationship_id
3762: FROM hz_org_contacts
3763: WHERE org_contact_id = x_org_contact_id )

Line 4345: FROM HZ_RELATIONSHIPS rel

4341: FROM HZ_ORG_CONTACTS
4342: WHERE ORG_CONTACT_ID = p_from_org_contact_id )
4343: AND EXISTS (
4344: SELECT 'same relationships'
4345: FROM HZ_RELATIONSHIPS rel
4346: WHERE rel.RELATIONSHIP_ID = org.PARTY_RELATIONSHIP_ID
4347: AND rel.OBJECT_ID = p_to_party_id
4348: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4349: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 4355: FROM HZ_RELATIONSHIPS,HZ_CUST_ACCOUNTS ACCT

4351: AND TO_CHAR(SUBJECT_ID) ||
4352: RELATIONSHIP_CODE = (
4353: SELECT TO_CHAR(SUBJECT_ID) ||
4354: RELATIONSHIP_CODE
4355: FROM HZ_RELATIONSHIPS,HZ_CUST_ACCOUNTS ACCT
4356: WHERE RELATIONSHIP_ID =
4357: p_from_party_rel_id
4358: AND OBJECT_ID = ACCT.PARTY_ID
4359: AND ACCT.CUST_ACCOUNT_ID = p_from_account_id