APPS.IEU_WPACTIONS_PVT dependencies on HZ_RELATIONSHIPS

Line 962: from hz_relationships a, hz_parties b

958:
959: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
960: l_continue := 0;
961: select count(a.object_id) into l_continue
962: from hz_relationships a, hz_parties b
963: where b.party_type = 'PARTY_RELATIONSHIP'
964: and a.party_id in (select source_object_id
965: from jtf_tasks_b
966: where task_id = l_task_rec_tbl(i).id)

Line 974: from hz_relationships a, hz_parties b

970: AND DIRECTIONAL_FLAG = 'F';
971:
972: if (l_continue > 0) then
973: select a.object_id into l_note_context_type_id
974: from hz_relationships a, hz_parties b
975: where b.party_type = 'PARTY_RELATIONSHIP'
976: and a.party_id in (select source_object_id
977: from jtf_tasks_b
978: where task_id = l_task_rec_tbl(i).id)

Line 1026: from hz_relationships a, hz_parties b

1022:
1023: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1024: l_continue := 0;
1025: select count(a.subject_id) into l_continue
1026: from hz_relationships a, hz_parties b
1027: where b.party_type = 'PARTY_RELATIONSHIP'
1028: and a.party_id = (select source_object_id
1029: from jtf_tasks_b
1030: where task_id = l_task_rec_tbl(i).id)

Line 1038: from hz_relationships a, hz_parties b

1034: AND DIRECTIONAL_FLAG = 'F';
1035:
1036: if (l_continue > 0) then
1037: select a.subject_id into l_note_context_type_id
1038: from hz_relationships a, hz_parties b
1039: where b.party_type = 'PARTY_RELATIONSHIP'
1040: and a.party_id = (select source_object_id
1041: from jtf_tasks_b
1042: where task_id = l_task_rec_tbl(i).id)