APPS.BIS_TREND_PLUG dependencies on BIS_SCHEDULE_PREFERENCES

Line 299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l

295: , l_parameters
296: , l_fn_responsibility_id
297: , l_schedule_id
298: , l_file_content_type
299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l
300: WHERE sp.USER_ID = l_user_id
301: AND sp.PLUG_ID = p_plug_id
302: AND sp.schedule_id = s.schedule_id
303: AND ff.function_name = s.function_name

Line 1221: FROM bis_schedule_preferences

1217: lUserId NUMBER;
1218:
1219: CURSOR userRowInBisScheduler IS
1220: SELECT user_id
1221: FROM bis_schedule_preferences
1222: WHERE plug_id=pPlugId
1223: AND user_id =to_char(pUserId);
1224:
1225: BEGIN

Line 1696: -- Plug id exists in bis_schedule_preferences, but,

1692:
1693: BIS_RL_PKG.add_rl_from_function( pFunctionName , pUserId , pPlugId);
1694: ELSE
1695: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
1696: -- Plug id exists in bis_schedule_preferences, but,
1697: -- check custom table also, just incase user has deleted links manually
1698: select count(*) into lIsCustomised from bis_custom_related_links where function_id = pPlugId and level_user_id = pUserId;
1699:
1700: if lIsCustomised = 0 then