APPS.FND_MANAGER dependencies on FND_CONCURRENT_TIME_PERIODS

Line 846: ws_id fnd_concurrent_time_periods.concurrent_time_period_id%TYPE;

842: last_updated_by IN VARCHAR2 DEFAULT NULL) is
843:
844: mgr_appl_id fnd_application.application_id%TYPE;
845: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
846: ws_id fnd_concurrent_time_periods.concurrent_time_period_id%TYPE;
847: dg_id fnd_data_groups.data_group_id%TYPE;
848: lib_appl_id fnd_application.application_id%TYPE;
849: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
850: mgr_type fnd_concurrent_queues.manager_type%TYPE;

Line 901: from fnd_concurrent_time_periods

897: begin
898: if (work_shift_id is not null) then
899: select concurrent_time_period_id
900: into ws_id
901: from fnd_concurrent_time_periods
902: where concurrent_time_period_id = work_shift_id
903: and application_id = 0;
904: else
905: select concurrent_time_period_id

Line 907: from fnd_concurrent_time_periods

903: and application_id = 0;
904: else
905: select concurrent_time_period_id
906: into ws_id
907: from fnd_concurrent_time_periods
908: where concurrent_time_period_name = work_shift
909: and application_id = 0;
910: end if;
911: exception

Line 1308: fnd_concurrent_time_periods tp

1304: if (work_shift_id is null) then
1305: select 'Y'
1306: into dummy
1307: from fnd_concurrent_queue_size qs,
1308: fnd_concurrent_time_periods tp
1309: where tp.concurrent_time_period_name = work_shift
1310: and tp.application_id = 0
1311: and tp.concurrent_time_period_id = qs.concurrent_time_period_id
1312: and qs.concurrent_queue_id = mgr_id