DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_STATE_RESPONSIBILITIES

Line 195: FROM jtf_state_responsibilities re

191: RETURN VARCHAR2 IS
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

Line 207: FROM jtf_state_responsibilities re

203:
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

Line 258: FROM jtf_state_responsibilities re

254:
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)

Line 272: FROM jtf_state_responsibilities re

268:
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)