APPS.ARH_CONT_PKG dependencies on HZ_RELATIONSHIPS

Line 144: FROM HZ_RELATIONSHIPS

140: SELECT ROWID,
141: OBJECT_VERSION_NUMBER,
142: LAST_UPDATE_DATE,
143: PARTY_ID
144: FROM HZ_RELATIONSHIPS
145: WHERE RELATIONSHIP_ID = p_col_id
146: AND DIRECTIONAL_FLAG = 'F';
147:
148: CURSOR cu_contact_pt_version IS

Line 182: ELSIF p_table_name = 'HZ_RELATIONSHIPS' THEN

178: l_last_update_date ,
179: x_id_value;
180: CLOSE cu_org_contact_version ;
181:
182: ELSIF p_table_name = 'HZ_RELATIONSHIPS' THEN
183: OPEN cu_relationship_version;
184: FETCH cu_relationship_version INTO
185: x_rowid ,
186: x_object_version_number,

Line 282: hz_relationships rel

278: from dual
279: where not exists ( select 1
280: from hz_cust_account_roles acct_role,
281: hz_parties party,
282: hz_relationships rel
283: where acct_role.party_id = rel.party_id
284: and acct_role.role_type = 'CONTACT'
285: and rel.subject_id = party.party_id
286: and party.person_last_name = x_last_name

Line 868: FROM hz_relationships p,

864: IF i_create_org_contact = 'N' THEN
865:
866: SELECT p.party_id
867: INTO cpoint_rec.owner_table_id
868: FROM hz_relationships p,
869: hz_org_contacts o
870: WHERE o.org_contact_id = x_org_contact_id
871: AND o.party_relationship_id = p.relationship_id
872: AND p.subject_table_name = 'HZ_PARTIES'

Line 1434: p_table_name => 'HZ_RELATIONSHIPS',

1430: --HYU
1431: l_rel_object_version := x_rel_object_version;
1432: IF l_rel_object_version = -1 THEN
1433: object_version_select(
1434: p_table_name => 'HZ_RELATIONSHIPS',
1435: p_col_id => l_rel_id,
1436: x_rowid => l_rel_rowid,
1437: x_object_version_number => l_rel_object_version,
1438: x_last_update_date => l_rel_last_update_date,

Line 1564: from hz_relationships

1560: select last_update_date,
1561: object_version_number
1562: into X_prel_Last_Update_Date,
1563: x_rel_object_version
1564: from hz_relationships
1565: where relationship_id = x_party_relationship_id
1566: AND subject_table_name = 'HZ_PARTIES'
1567: AND object_table_name = 'HZ_PARTIES'
1568: AND directional_flag = 'F';

Line 1572: from hz_relationships

1568: AND directional_flag = 'F';
1569:
1570: select party_id
1571: into i_rel_party_id
1572: from hz_relationships
1573: where relationship_id = x_party_relationship_id
1574: AND subject_table_name = 'HZ_PARTIES'
1575: AND object_table_name = 'HZ_PARTIES'
1576: AND directional_flag = 'F';