DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on DUAL

Line 51: select 'N' into l_allow_merge_flag from dual

47: IBE_Util.Debug('IBE_MERGE_PVT.Allow_merge -party_type: '||l_party_type||' party_id: '||l_party_id||' and duplicate party id: '||l_dup_party_id);
48:
49: If ((l_Party_type = 'ORGANIZATION') AND (l_party_id <> l_dup_party_id)) Then
50: BEGIN
51: select 'N' into l_allow_merge_flag from dual
52: where exists (
53: select u.user_id from fnd_user u, fnd_user_resp_groups g, HZ_RELATIONSHIPS r
54: where u.user_id = g.user_id and g.responsibility_application_id=671
55: and u.customer_id= r.party_id and r.object_id = l_party_id