APPS.GCS_FEM_HIER_SYNC_PKG dependencies on FEM_USER_FOLDERS

Line 37: FROM fem_user_folders fuf

33: --Bugfix 5744068: Check folder access prior to executing loader
34: BEGIN
35: SELECT 'Y'
36: INTO l_user_assigned_flag
37: FROM fem_user_folders fuf
38: WHERE fuf.folder_id = 1100
39: AND fuf.user_id = FND_GLOBAL.USER_ID;
40: EXCEPTION
41: WHEN NO_DATA_FOUND THEN

Line 55: FROM fem_user_folders fuf

51: --Bugfix 5744068: Check folder access prior to executing loader
52: BEGIN
53: SELECT 'Y'
54: INTO l_user_assigned_flag
55: FROM fem_user_folders fuf
56: WHERE fuf.folder_id = 1000
57: AND fuf.user_id = FND_GLOBAL.USER_ID;
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN