APPS.IBE_MERGE_PVT dependencies on FND_USER

Line 31: l_user_id FND_USER.USER_ID%TYPE;

27: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
28: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
29: l_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;
30: l_rel_party_id HZ_PARTIES.PARTY_ID%TYPE;
31: l_user_id FND_USER.USER_ID%TYPE;
32:
33: CURSOR party_rel(p_party_id NUMBER) IS
34: Select party_id
35: From HZ_RELATIONSHIPS

Line 62: From fnd_user_resp_groups

58:
59: Begin
60:
61: Select user_id into l_user_id
62: From fnd_user_resp_groups
63: Where user_id in (Select user_id from fnd_user
64: Where customer_id = l_rel_party_id)
65: And responsibility_application_id = 671;
66: Exception

Line 63: Where user_id in (Select user_id from fnd_user

59: Begin
60:
61: Select user_id into l_user_id
62: From fnd_user_resp_groups
63: Where user_id in (Select user_id from fnd_user
64: Where customer_id = l_rel_party_id)
65: And responsibility_application_id = 671;
66: Exception
67: When NO_DATA_FOUND Then