DBA Data[Home] [Help]

APPS.CSM_UTIL_PKG dependencies on FND_RESPONSIBILITY

Line 1711: FROM FND_RESPONSIBILITY resp, fnd_application app

1707: l_application_id NUMBER;
1708:
1709: CURSOR l_get_resp_id IS
1710: SELECT resp.APPLICATION_ID, resp.RESPONSIBILITY_ID
1711: FROM FND_RESPONSIBILITY resp, fnd_application app
1712: WHERE resp.RESPONSIBILITY_KEY = 'OMFS_PALM'
1713: AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
1714: AND app.application_id = resp.application_id
1715: AND app.application_short_name = 'CSM';