APPS.IEU_WPACTIONS_PVT dependencies on HZ_RELATIONSHIPS

Line 981: from hz_relationships a, hz_parties b

977:
978: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
979: l_continue := 0;
980: select count(a.object_id) into l_continue
981: from hz_relationships a, hz_parties b
982: where b.party_type = 'PARTY_RELATIONSHIP'
983: and a.party_id in (select source_object_id
984: from jtf_tasks_b
985: where task_id = l_task_rec_tbl(i).id)

Line 993: from hz_relationships a, hz_parties b

989: AND DIRECTIONAL_FLAG = 'F';
990:
991: if (l_continue > 0) then
992: select a.object_id into l_note_context_type_id
993: from hz_relationships a, hz_parties b
994: where b.party_type = 'PARTY_RELATIONSHIP'
995: and a.party_id in (select source_object_id
996: from jtf_tasks_b
997: where task_id = l_task_rec_tbl(i).id)

Line 1045: from hz_relationships a, hz_parties b

1041:
1042: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1043: l_continue := 0;
1044: select count(a.subject_id) into l_continue
1045: from hz_relationships a, hz_parties b
1046: where b.party_type = 'PARTY_RELATIONSHIP'
1047: and a.party_id = (select source_object_id
1048: from jtf_tasks_b
1049: where task_id = l_task_rec_tbl(i).id)

Line 1057: from hz_relationships a, hz_parties b

1053: AND DIRECTIONAL_FLAG = 'F';
1054:
1055: if (l_continue > 0) then
1056: select a.subject_id into l_note_context_type_id
1057: from hz_relationships a, hz_parties b
1058: where b.party_type = 'PARTY_RELATIONSHIP'
1059: and a.party_id = (select source_object_id
1060: from jtf_tasks_b
1061: where task_id = l_task_rec_tbl(i).id)