DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on FND_RESPONSIBILITY

Line 1918: from fnd_responsibility resp

1914: IF pTASK = MSC_UTIL.TASK_COLL THEN
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'

Line 1930: from fnd_responsibility resp,

1926: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
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'

Line 1973: from fnd_responsibility resp,

1969: IF pTASK = MSC_UTIL.TASK_COLL THEN
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'

Line 1985: from fnd_responsibility resp,

1981: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
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'