APPS.CZ_SECURITY_PVT dependencies on FND_USER

Line 633: ----@p_user_name : fnd user ex: OPERATIONS

629:
630: --------------------------------------------------------------------
631: --------check privilege
632: ----@p_api_version : api version current version is 1.0
633: ----@p_user_name : fnd user ex: OPERATIONS
634: ----@p_function_name : fnd function , function name of the task
635: ----@p_entity_type : Fnd_objects.obj_name ex MODEL, UI RULEFOLDER
636: ----for the above use global constants
637: ----@p_instance_pk1_value : primary key of the object ex devl_project_id or rule_folder_id

Line 1219: FROM fnd_user

1215:
1216: BEGIN
1217: SELECT user_id
1218: INTO l_user_id
1219: FROM fnd_user
1220: WHERE user_name = UPPER(p_user_name);
1221: RETURN l_user_id;
1222: END get_user_id;
1223:

Line 2951: FROM fnd_user

2947: IS
2948: l_user_name VARCHAR2(100);
2949: BEGIN
2950: SELECT user_name INTO l_user_name
2951: FROM fnd_user
2952: WHERE user_id = p_user_id ;
2953: RETURN l_user_name ;
2954: EXCEPTION
2955: WHEN OTHERS THEN

Line 2964: CURSOR resp_cur IS SELECT responsibility_id from FND_USER_RESP_GROUPS

2960: FUNCTION get_resp_name (p_user_id IN NUMBER)
2961: RETURN VARCHAR2
2962: IS
2963:
2964: CURSOR resp_cur IS SELECT responsibility_id from FND_USER_RESP_GROUPS
2965: WHERE user_id = p_user_id
2966: AND responsibility_application_id = 708;
2967:
2968: l_responsibility_id NUMBER := 0;