191: select
192: (select
193: 'TRUE'
194: from
195: jtf_task_audits_b jtab,
196: jtf_tasks_b jtb
197: where
198: jtb.task_id = v_task_id
199: and jtb.source_object_type_code = 'SR'
203: or jtab.new_scheduled_end_date <> jtab.old_scheduled_end_date)) as is_schedule_dates,
204: (select
205: 'TRUE'
206: from
207: jtf_task_audits_b jtab,
208: jtf_tasks_b jtb
209: where
210: jtb.task_id = v_task_id
211: and jtb.source_object_type_code = 'SR'
229: 'TRUE'
230: from
231: jtf_task_priorities_vl jp_vl1,
232: jtf_task_priorities_vl jp_vl2,
233: jtf_task_audits_b jtab
234: where
235: jtab.task_id = v_task_id
236: and jtab.task_audit_id = v_task_audit_id
237: and jp_vl1.task_priority_id = jtab.new_task_priority_id
2660: jtab.old_scheduled_start_date old_sch_st_date,
2661: jtab.old_scheduled_end_date old_sch_end_date
2662: FROM
2663: jtf_tasks_b jtb,
2664: jtf_task_audits_b jtab,
2665: jtf_tasks_vl j_vl,
2666: jtf_task_priorities_vl jp_vl,
2667: cs_incidents_all c_b,
2668: hz_party_sites hps,