Line 43: select middleware_id into x_middleware_id from cct_telesets where teleset_id =
39: -- API body
40:
41: x_middleware_id := -1;
42: 43: select middleware_id into x_middleware_id from cct_telesets where teleset_id = 44: (select client_id from cct_agent_rt_stats where attribute1='T' and agent_id = p_agent_id);
45:
46: -- End of API body.
47: -- Standard check of p_commit.