DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_TASK_STATUSES_TL

Line 311: , jtf_task_statuses_tl ts

307: SELECT DISTINCT tr.initial_state_id, ts.name
308: FROM jtf_state_responsibilities re
309: , jtf_state_rules_b ru
310: , jtf_state_transitions tr
311: , jtf_task_statuses_tl ts
312: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
313: AND re.rule_id = ru.rule_id
314: AND ru.state_type = p_state_type
315: AND ru.rule_id = tr.rule_id

Line 325: , jtf_task_statuses_tl ts

321: SELECT DISTINCT tr.final_state_id, ts.name
322: FROM jtf_state_responsibilities re
323: , jtf_state_rules_b ru
324: , jtf_state_transitions tr
325: , jtf_task_statuses_tl ts
326: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
327: AND re.rule_id = ru.rule_id
328: AND ru.state_type = p_state_type
329: AND ru.rule_id = tr.rule_id