[Home] [Help]
269: -- ntungare Tue Mar 28 08:02:43 PST 2006.
270: --
271: CURSOR cur_mesg(p_plan_id NUMBER,p_char_id NUMBER) IS
272: SELECT message
273: FROM qa_plan_char_actions
274: WHERE plan_char_action_trigger_id IN
275: (SELECT plan_char_action_trigger_id
276: FROM qa_plan_char_action_triggers
277: WHERE plan_id = p_plan_id
1152: -- ntungare Tue Mar 28 08:07:05 PST 2006.
1153: --
1154: CURSOR cur_mesg(p_plan_id NUMBER,p_char_id NUMBER) IS
1155: SELECT message
1156: FROM qa_plan_char_actions
1157: WHERE plan_char_action_trigger_id IN
1158: (SELECT plan_char_action_trigger_id
1159: FROM qa_plan_char_action_triggers
1160: WHERE plan_id = p_plan_id