APPS.CSL_SERVICE_HISTORY_PKG dependencies on ASG_USER
Line 109: , ASG_USER au
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))
113: AND TRUNC(NVL(fur.end_date,sysdate));