APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on JTF_STATE_RULES_B

Line 18: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule

14: WHERE acc.USER_ID = p_user_id
15: AND STATE_TRANSITION_ID not in (SELECT STATE_TRANSITION_ID
16: FROM JTF_STATE_TRANSITIONS trn
17: WHERE RULE_ID IN (SELECT sresp.RULE_ID
18: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
19: WHERE RESPONSIBILITY_ID = p_resp_id
20: AND sresp.RULE_ID = srule.RULE_ID
21: AND srule.STATE_TYPE = 'TASK_STATUS'));
22:

Line 78: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule

74: CURSOR l_inserts_cur IS
75: SELECT CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL,p_user_id,trn.state_transition_id
76: FROM JTF_STATE_TRANSITIONS trn
77: WHERE trn.RULE_ID IN (SELECT sresp.RULE_ID
78: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
79: WHERE sresp.RULE_ID = srule.RULE_ID
80: AND srule.STATE_TYPE = 'TASK_STATUS'
81: AND RESPONSIBILITY_ID = p_resp_id )
82: AND not exists (SELECT 1 FROM CSM_STATE_TRANSITIONS_ACC acc