DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on FND_USER

Line 61: FROM FND_USER

57:
58: BEGIN
59: SELECT USER_ID
60: INTO lv_user_id
61: FROM FND_USER
62: WHERE USER_NAME = p_user_name;
63: EXCEPTION
64: WHEN NO_DATA_FOUND THEN
65: raise_application_error (-20001, 'User not defined on Source instance');

Line 1987: FROM FND_USER

1983: BEGIN
1984:
1985: SELECT USER_ID
1986: INTO l_user_id
1987: FROM FND_USER
1988: WHERE USER_NAME = p_user_name;
1989:
1990: EXCEPTION
1991: WHEN NO_DATA_FOUND THEN

Line 2052: , FND_USER_RESP_GROUPS user_resp

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'
2056: and user_resp.user_id = pUSERID

Line 2064: FND_USER_RESP_GROUPS user_resp

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'
2068: and user_resp.user_id = pUSERID

Line 2547: FND_USER_RESP_GROUPS user_resp

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'
2551: and user_resp.user_id = pUSERID

Line 2559: FND_USER_RESP_GROUPS user_resp

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'
2563: and user_resp.user_id = pUSERID