DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on FND_USER_RESP_GROUPS

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