DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on JTF_TASK_AUDITS_B

Line 195: jtf_task_audits_b jtab,

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'

Line 207: jtf_task_audits_b jtab,

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'

Line 233: jtf_task_audits_b jtab

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

Line 2664: jtf_task_audits_b jtab,

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,