APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 384: select profile_option_value from fnd_profile_option_values where profile_option_id in

380: AND procedure_name = 'PURGE_NOTIFICATION_CONC'
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;

Line 1729: select to_number(profile_option_value) INTO l_server_tz from fnd_profile_option_values where profile_option_id in

1725: l_increment NUMBER;
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,