APPS.CSF_TASKS_PUB dependencies on JTF_STATE_RULES_B

Line 246: , jtf_state_rules_b ru

242: -- Validation when new object
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

Line 258: , jtf_state_rules_b ru

254: -- Validation when existing object
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

Line 309: , jtf_state_rules_b ru

305: -- Get valid statuses when the object is creeted for the first time
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

Line 323: , jtf_state_rules_b ru

319: -- Get valid statuses from an existing status
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