DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on JTF_TASK_AUDITS_B

Line 192: jtf_task_audits_b

188: select
189: (select
190: 'TRUE'
191: from
192: jtf_task_audits_b
193: where
194: task_id = v_task_id
195: and task_audit_id = v_task_audit_id
196: and (new_scheduled_start_date <> old_scheduled_start_date

Line 201: jtf_task_audits_b

197: or new_scheduled_end_date <> old_scheduled_end_date)) as is_schedule_dates,
198: (select
199: 'TRUE'
200: from
201: jtf_task_audits_b
202: where
203: task_id = v_task_id
204: and task_audit_id = v_task_audit_id
205: and new_task_priority_id <> old_task_priority_id) as is_priority

Line 224: jtf_task_audits_b jtab

220: 'TRUE'
221: from
222: jtf_task_priorities_vl jp_vl1,
223: jtf_task_priorities_vl jp_vl2,
224: jtf_task_audits_b jtab
225: where
226: jtab.task_id = v_task_id
227: and jtab.task_audit_id = v_task_audit_id
228: and jp_vl1.task_priority_id = jtab.new_task_priority_id

Line 2654: jtf_task_audits_b jtab,

2650: jtab.old_scheduled_start_date old_sch_st_date,
2651: jtab.old_scheduled_end_date old_sch_end_date
2652: FROM
2653: jtf_tasks_b jtb,
2654: jtf_task_audits_b jtab,
2655: jtf_tasks_vl j_vl,
2656: jtf_task_priorities_vl jp_vl,
2657: cs_incidents_all c_b,
2658: hz_party_sites hps,