APPS.FND_CONCURRENT dependencies on FND_USER

Line 2713: FROM fnd_user

2709: l_resp_id number := -1;
2710: l_ret_value number := 0;
2711: CURSOR l_user_csr(p_user_name varchar2) IS
2712: SELECT user_id
2713: FROM fnd_user
2714: WHERE user_name = upper(p_user_name);
2715: CURSOR l_resp_csr IS
2716: SELECT responsibility_id
2717: FROM fnd_responsibility

Line 2721: FROM fnd_user_resp_groups

2717: FROM fnd_responsibility
2718: WHERE responsibility_key = 'SYSTEM_ADMINISTRATOR';
2719: CURSOR l_user_resp_csr( p_user_id number, p_responsibility_id number)IS
2720: SELECT count(responsibility_id)
2721: FROM fnd_user_resp_groups
2722: WHERE user_id = p_user_id
2723: AND responsibility_id = p_responsibility_id;
2724: BEGIN
2725: IF (p_test_code <> 'STARTMGR' and p_test_code <> 'RUNCONCPROG') THEN

Line 2767: FROM fnd_user_resp_groups

2763: p_resp_id number,
2764: p_resp_appl_id number,
2765: p_sec_group_id number)IS
2766: SELECT count(responsibility_id)
2767: FROM fnd_user_resp_groups
2768: WHERE user_id = p_user_id
2769: AND responsibility_id = p_resp_id
2770: AND responsibility_application_id = p_resp_appl_id
2771: AND security_group_id = p_sec_group_id;

Line 2775: FROM fnd_user

2771: AND security_group_id = p_sec_group_id;
2772:
2773: CURSOR l_user_csr(p_user_name varchar2) IS
2774: SELECT user_id
2775: FROM fnd_user
2776: WHERE user_name = p_user_name;
2777:
2778: CURSOR l_appl_id_csr(p_application_short_name varchar2) IS
2779: SELECT application_id