APPS.CSF_TASKS_PUB dependencies on JTF_STATE_RULES_B

Line 196: , jtf_state_rules_b ru

192: -- Validation when new object
193: CURSOR c_valid_new_trans IS
194: SELECT NULL
195: FROM jtf_state_responsibilities re
196: , jtf_state_rules_b ru
197: , jtf_state_transitions tr
198: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
199: AND re.rule_id = ru.rule_id
200: AND ru.state_type = p_state_type

Line 208: , jtf_state_rules_b ru

204: -- Validation when existing object
205: CURSOR c_valid_existing_trans IS
206: SELECT NULL
207: FROM jtf_state_responsibilities re
208: , jtf_state_rules_b ru
209: , jtf_state_transitions tr
210: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
211: AND re.rule_id = ru.rule_id
212: AND ru.state_type = p_state_type

Line 259: , jtf_state_rules_b ru

255: -- Get valid statuses when the object is creeted for the first time
256: CURSOR c_valid_new_trans IS
257: SELECT DISTINCT tr.initial_state_id, ts.name
258: FROM jtf_state_responsibilities re
259: , jtf_state_rules_b ru
260: , jtf_state_transitions tr
261: , jtf_task_statuses_tl ts
262: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
263: AND re.rule_id = ru.rule_id

Line 273: , jtf_state_rules_b ru

269: -- Get valid statuses from an existing status
270: CURSOR c_valid_existing_trans IS
271: SELECT DISTINCT tr.final_state_id, ts.name
272: FROM jtf_state_responsibilities re
273: , jtf_state_rules_b ru
274: , jtf_state_transitions tr
275: , jtf_task_statuses_tl ts
276: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
277: AND re.rule_id = ru.rule_id