APPS.CSL_SERVICE_HISTORY_PKG dependencies on FND_USER_RESP_GROUPS
Line 108: FROM FND_USER_RESP_GROUPS fur
104: CURSOR c_responsibilities( b_resource_id NUMBER ) IS
105: SELECT fur.USER_ID
106: , fur.RESPONSIBILITY_ID
107: , fur.RESPONSIBILITY_APPLICATION_ID 108: FROM FND_USER_RESP_GROUPS fur 109: , ASG_USER au
110: WHERE au.RESOURCE_ID = b_resource_id
111: AND au.USER_ID = fur.USER_ID
112: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(fur.start_date,sysdate))