DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_STATE_TRANSITIONS

Line 247: , jtf_state_transitions tr

243: CURSOR c_valid_new_trans IS
244: SELECT NULL
245: FROM jtf_state_responsibilities re
246: , jtf_state_rules_b ru
247: , jtf_state_transitions tr
248: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
249: AND re.rule_id = ru.rule_id
250: AND ru.state_type = p_state_type
251: AND ru.rule_id = tr.rule_id

Line 259: , jtf_state_transitions tr

255: CURSOR c_valid_existing_trans IS
256: SELECT NULL
257: FROM jtf_state_responsibilities re
258: , jtf_state_rules_b ru
259: , jtf_state_transitions tr
260: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
261: AND re.rule_id = ru.rule_id
262: AND ru.state_type = p_state_type
263: AND ru.rule_id = tr.rule_id

Line 310: , jtf_state_transitions tr

306: CURSOR c_valid_new_trans IS
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

Line 324: , jtf_state_transitions tr

320: CURSOR c_valid_existing_trans IS
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