APPS.FND_CONCURRENT dependencies on FND_USER

Line 2822: FROM fnd_user

2818: l_resp_id number := -1;
2819: l_ret_value number := 0;
2820: CURSOR l_user_csr(p_user_name varchar2) IS
2821: SELECT user_id
2822: FROM fnd_user
2823: WHERE user_name = upper(p_user_name);
2824: CURSOR l_resp_csr(p_responsibility_key varchar2) IS
2825: SELECT responsibility_id
2826: FROM fnd_responsibility

Line 2830: FROM fnd_user_resp_groups

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

Line 2887: FROM fnd_user_resp_groups

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;

Line 2895: FROM fnd_user

2891: AND security_group_id = p_sec_group_id;
2892:
2893: CURSOR l_user_csr(p_user_name varchar2) IS
2894: SELECT user_id
2895: FROM fnd_user
2896: WHERE user_name = upper(p_user_name);
2897:
2898: CURSOR l_appl_id_csr(p_application_short_name varchar2) IS
2899: SELECT application_id