[Home] [Help]
216: -- ntungare Tue Mar 28 08:02:43 PST 2006.
217: --
218: CURSOR cur_mesg(p_plan_id NUMBER,p_char_id NUMBER) IS
219: SELECT message
220: FROM qa_plan_char_actions
221: WHERE plan_char_action_trigger_id IN
222: (SELECT plan_char_action_trigger_id
223: FROM qa_plan_char_action_triggers
224: WHERE plan_id = p_plan_id
1083: -- ntungare Tue Mar 28 08:07:05 PST 2006.
1084: --
1085: CURSOR cur_mesg(p_plan_id NUMBER,p_char_id NUMBER) IS
1086: SELECT message
1087: FROM qa_plan_char_actions
1088: WHERE plan_char_action_trigger_id IN
1089: (SELECT plan_char_action_trigger_id
1090: FROM qa_plan_char_action_triggers
1091: WHERE plan_id = p_plan_id