DBA Data[Home] [Help]

APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on CSM_STATE_TRANSITIONS_ACC_S

Line 75: SELECT CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL,p_user_id,trn.state_transition_id

71: l_acc_tab asg_download.access_list;
72: l_str_tab asg_download.access_list;
73:
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