[Home] [Help]
430: arg_refresh_number
431: FROM msc_shift_dates dates,
432: msc_shift_times shifts,
433: msc_resource_shifts res_shifts,
434: msc_department_resources dept_res1,
435: msc_dept_res_instances dept_ins,
436: msc_trading_partners param
437: WHERE dates.calendar_code = param.calendar_code
438: AND dates.exception_set_id = param.calendar_exception_set_id
546: var_gt_conc_program,
547: sysdate,
548: arg_refresh_number
549: FROM msc_calendar_dates dates,
550: msc_department_resources dept_res1,
551: msc_dept_res_instances dept_ins,
552: msc_trading_partners param
553: WHERE dates.calendar_code = param.calendar_code
554: AND dates.exception_set_id = param.calendar_exception_set_id
831: dept_res.disable_date --, --**
832: --org.calendar_code, --**
833: -- org.calendar_exception_set_id --**
834: FROM msc_trading_partners org,
835: msc_department_resources dept_res,
836: msc_dept_res_instances dept_ins
837: WHERE dept_res.owning_department_id = dept_res.department_id
838: AND dept_res.plan_id = -1
839: AND dept_res.resource_id <> -1
872: --org.calendar_code, --**
873: -- org.calendar_exception_set_id --**
874: FROM msc_trading_partners org,
875: msc_resource_changes chg,
876: msc_department_resources dept_res,
877: msc_res_instance_changes res_ins
878: WHERE chg.department_id = dept_res.department_id
879: AND chg.resource_id = dept_res.resource_id
880: AND chg.sr_instance_id = dept_res.sr_instance_id
1073: delete from msc_net_res_inst_avail
1074: where rowid in (select res.rowid
1075: from msc_net_res_inst_avail res,
1076: msc_resource_changes chg,
1077: msc_department_resources dept
1078: where res.organization_id = arg_organization_id
1079: and res.sr_instance_id = arg_sr_instance_id
1080: and res.plan_id = -1
1081: and res.department_id = chg.department_id