APPS.HZ_WF_SYNCH dependencies on HZ_RELATIONSHIPS

Line 154: from hz_relationships rel,

150: l_debug_prefix VARCHAR2(30) := '';
151:
152: Cursor find_contacts is
153: select party_id
154: from hz_relationships rel,
155: hz_org_contacts org
156: where rel.relationship_id=org.party_relationship_id and
157: Subject_table_name = 'HZ_PARTIES' and
158: Object_table_name = 'HZ_PARTIES' and

Line 164: from hz_relationships rel,

160: subject_id = wf_party_id;
161:
162: Cursor org_update is
163: select party_id
164: from hz_relationships rel,
165: hz_org_contacts org
166: where rel.relationship_id=org.party_relationship_id and
167: Subject_table_name = 'HZ_PARTIES' and
168: Object_table_name = 'HZ_PARTIES' and

Line 393: from hz_org_contacts org, hz_relationships rel

389: -- anonymous block to find the orgContact
390: BEGIN
391: select party_id
392: into wf_party_id
393: from hz_org_contacts org, hz_relationships rel
394: where org.party_relationship_id=rel.relationship_id and
395: Subject_table_name = 'HZ_PARTIES' and
396: Object_table_name = 'HZ_PARTIES' and
397: Directional_flag = 'F' and

Line 439: from hz_org_contacts org, hz_relationships rel

435: -- anonymous block to find the orgContact
436: BEGIN
437: select party_id
438: into wf_party_id
439: from hz_org_contacts org, hz_relationships rel
440: where org.party_relationship_id=rel.relationship_id and
441: Subject_table_name = 'HZ_PARTIES' and
442: Object_table_name = 'HZ_PARTIES' and
443: Directional_flag = 'F' and

Line 988: hz_relationships pr

984: ELSE SYSDATE
985: END), SYSDATE) -- ExpirationDate --Bug#5209709 fix
986: ,pr.party_id -- system_id
987: FROM
988: hz_relationships pr
989: ,hz_org_contacts oc
990: ,hz_parties prp -- party relationship party
991: ,hz_parties per
992: ,hz_contact_points cp

Line 1441: hz_relationships pr

1437: role_system_id,
1438: start_date,
1439: expiration_date
1440: FROM
1441: hz_relationships pr
1442: ,hz_parties sp
1443: ,hz_parties op
1444: WHERE
1445: pr.relationship_id = RelationshipId