APPS.EAM_DEPT_APPROVERS_PUB dependencies on FND_USER_RESP_GROUPS

Line 107: FROM FND_USER_RESP_GROUPS GRP WHERE USER_ID = P_PRIMARY_APPROVER_ID

103: end if;
104:
105: -- primary_approver_id HAS TO BE VALID USER WITH VALID RESPONSIBILITY ID
106: select count(*) into l_count
107: FROM FND_USER_RESP_GROUPS GRP WHERE USER_ID = P_PRIMARY_APPROVER_ID
108: AND RESPONSIBILITY_ID = P_RESPONSIBILITY_ID;
109:
110: if l_count = 0
111: then