APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on FND_PROFILE_OPTIONS

Line 385: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')

381: FOR UPDATE OF last_run_date NOWAIT;
382:
383: CURSOR c_purge_days IS
384: select profile_option_value from fnd_profile_option_values where profile_option_id in
385: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')
386: and level_id=10001;
387:
388: l_days NUMBER;
389:

Line 1730: (select profile_option_id from fnd_profile_options where profile_option_name in ('SERVER_TIMEZONE_ID'))

1726: l_float NUMBER;
1727: l_dev VARCHAR2(10);
1728: BEGIN
1729: select to_number(profile_option_value) INTO l_server_tz from fnd_profile_option_values where profile_option_id in
1730: (select profile_option_id from fnd_profile_options where profile_option_name in ('SERVER_TIMEZONE_ID'))
1731: and level_id=10001;
1732:
1733: select next_day(add_months('1-JAN'||to_char(sysdate,'YYYY'),begin_dst_month-1) + ((begin_dst_week_of_month-1)*7)-1,
1734: decode(begin_dst_day_of_week, 1,'SUNDAY',2,'MONDAY',3,'TUESDAY',4,'WEDNESDAY',5,'THURSDAY',6,'FRIDAY',7,'SATURDAY')) + (begin_dst_hour/24) DST_BEGIN_DATE,