DBA Data[Home] [Help]

APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on FND_RESPONSIBILITY_VL

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

24: l_user_id NUMBER;
25: l_resp_id NUMBER;
26:
27: CURSOR get_resp_id_csr IS
28: select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;
29:
30: BEGIN
31: OPEN get_user_id_csr(p_user_id);
32: FETCH get_user_id_csr INTO l_user_id;