DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on FND_RESPONSIBILITY_VL

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

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