DBA Data[Home] [Help]

APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on JTF_STATE_RULES_B

Line 30: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule

26: (SELECT STATE_TRANSITION_ID
27: FROM JTF_STATE_TRANSITIONS trn
28: WHERE RULE_ID IN
29: (SELECT sresp.RULE_ID
30: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
31: WHERE RESPONSIBILITY_ID = p_responsibility_id
32: AND sresp.RULE_ID = srule.RULE_ID
33: AND srule.STATE_TYPE = 'TASK_STATUS' -- IN ('TASK_STATUS', 'SR_STATUS') AND APPLICATION_ID IN (513, 170)
34: )

Line 180: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule

176: 'SELECT trn.state_transition_id, trn.last_update_date
177: FROM JTF_STATE_TRANSITIONS trn
178: WHERE trn.RULE_ID IN
179: (SELECT sresp.RULE_ID
180: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
181: WHERE sresp.RULE_ID = srule.RULE_ID
182: AND srule.STATE_TYPE = ''TASK_STATUS''
183: AND RESPONSIBILITY_ID = :1 ) '
184: || ' AND trn.state_transition_id not in