DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on FND_RESPONSIBILITY

Line 2051: from fnd_responsibility resp

2047: IF pTASK = MSC_UTIL.TASK_COLL THEN
2048:
2049: select 1
2050: into lv_result
2051: from fnd_responsibility resp
2052: , FND_USER_RESP_GROUPS user_resp
2053: where resp.responsibility_id = user_resp.responsibility_id
2054: and resp.application_id = user_resp.responsibility_application_id
2055: and resp.responsibility_key = 'APS_COLLECTIONS'

Line 2063: from fnd_responsibility resp,

2059: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
2060:
2061: select 1
2062: into lv_result
2063: from fnd_responsibility resp,
2064: FND_USER_RESP_GROUPS user_resp
2065: where resp.responsibility_id = user_resp.responsibility_id
2066: and resp.application_id = user_resp.responsibility_application_id
2067: and resp.responsibility_key = 'APS_RELEASE'

Line 2546: from fnd_responsibility resp,

2542: IF pTASK = MSC_UTIL.TASK_COLL THEN
2543:
2544: select resp.responsibility_id, resp.application_id
2545: into lv_resp_id, lv_application_id
2546: from fnd_responsibility resp,
2547: FND_USER_RESP_GROUPS user_resp
2548: where resp.responsibility_id = user_resp.responsibility_id
2549: and resp.application_id = user_resp.responsibility_application_id
2550: and resp.responsibility_key = 'APS_COLLECTIONS'

Line 2558: from fnd_responsibility resp,

2554: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
2555:
2556: select resp.responsibility_id, resp.application_id
2557: into lv_resp_id, lv_application_id
2558: from fnd_responsibility resp,
2559: FND_USER_RESP_GROUPS user_resp
2560: where resp.responsibility_id = user_resp.responsibility_id
2561: and resp.application_id = user_resp.responsibility_application_id
2562: and resp.responsibility_key = 'APS_RELEASE'