DBA Data[Home] [Help]

APPS.AHL_WORKORDER_SEARCH_PUB dependencies on FND_RESPONSIBILITY_VL

Line 20: select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;

16: l_user_id NUMBER;
17: l_resp_id NUMBER;
18:
19: CURSOR get_resp_id_csr IS
20: select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;
21: BEGIN
22: OPEN get_user_id_csr(p_user_id);
23: FETCH get_user_id_csr INTO l_user_id;
24: IF get_user_id_csr%NOTFOUND THEN