APPS.CSM_PROFILE_PKG dependencies on FND_RESPONSIBILITY

Line 553: FROM FND_RESPONSIBILITY resp, fnd_application app

549:
550: CURSOR l_get_resp_id
551: IS
552: SELECT resp.APPLICATION_ID, resp.RESPONSIBILITY_ID
553: FROM FND_RESPONSIBILITY resp, fnd_application app
554: WHERE resp.RESPONSIBILITY_KEY = 'OMFS_PALM'
555: AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
556: AND app.application_id = resp.application_id
557: AND app.application_short_name = 'CSM';