DBA Data[Home] [Help]

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))