2826: FROM fnd_responsibility
2827: WHERE responsibility_key = p_responsibility_key;
2828: CURSOR l_user_resp_csr( p_user_id number, p_responsibility_id number)IS
2829: SELECT count(responsibility_id)
2830: FROM fnd_user_resp_groups
2831: WHERE user_id = p_user_id
2832: AND responsibility_id = p_responsibility_id;
2833: BEGIN
2834: IF (p_test_code <> 'STARTMGR' and p_test_code <> 'RUNCONCPROG') THEN
2883: p_resp_id number,
2884: p_resp_appl_id number,
2885: p_sec_group_id number)IS
2886: SELECT count(responsibility_id)
2887: FROM fnd_user_resp_groups
2888: WHERE user_id = p_user_id
2889: AND responsibility_id = p_resp_id
2890: AND responsibility_application_id = p_resp_appl_id
2891: AND security_group_id = p_sec_group_id;