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 1854: FROM FND_USER

1850: BEGIN
1851:
1852: SELECT USER_ID
1853: INTO l_user_id
1854: FROM FND_USER
1855: WHERE USER_NAME = p_user_name;
1856:
1857: EXCEPTION
1858: WHEN NO_DATA_FOUND THEN

Line 1919: , FND_USER_RESP_GROUPS user_resp

1915:
1916: select 1
1917: into lv_result
1918: from fnd_responsibility resp
1919: , FND_USER_RESP_GROUPS user_resp
1920: where resp.responsibility_id = user_resp.responsibility_id
1921: and resp.application_id = user_resp.responsibility_application_id
1922: and resp.responsibility_key = 'APS_COLLECTIONS'
1923: and user_resp.user_id = pUSERID

Line 1931: FND_USER_RESP_GROUPS user_resp

1927:
1928: select 1
1929: into lv_result
1930: from fnd_responsibility resp,
1931: FND_USER_RESP_GROUPS user_resp
1932: where resp.responsibility_id = user_resp.responsibility_id
1933: and resp.application_id = user_resp.responsibility_application_id
1934: and resp.responsibility_key = 'APS_RELEASE'
1935: and user_resp.user_id = pUSERID

Line 1974: FND_USER_RESP_GROUPS user_resp

1970:
1971: select resp.responsibility_id, resp.application_id
1972: into lv_resp_id, lv_application_id
1973: from fnd_responsibility resp,
1974: FND_USER_RESP_GROUPS user_resp
1975: where resp.responsibility_id = user_resp.responsibility_id
1976: and resp.application_id = user_resp.responsibility_application_id
1977: and resp.responsibility_key = 'APS_COLLECTIONS'
1978: and user_resp.user_id = pUSERID

Line 1986: FND_USER_RESP_GROUPS user_resp

1982:
1983: select resp.responsibility_id, resp.application_id
1984: into lv_resp_id, lv_application_id
1985: from fnd_responsibility resp,
1986: FND_USER_RESP_GROUPS user_resp
1987: where resp.responsibility_id = user_resp.responsibility_id
1988: and resp.application_id = user_resp.responsibility_application_id
1989: and resp.responsibility_key = 'APS_RELEASE'
1990: and user_resp.user_id = pUSERID