DBA Data[Home] [Help]

APPS.CSZ_INTERACTION_PVT dependencies on JTF_IH_ACTIONS_TL

Line 190: FROM jtf_ih_actions_tl

186: l_action_value := SR_UPDATE;
187: -- Retreives the valid actionID for SR update actions.
188: begin
189: SELECT nvl(action_id,0) into l_action_id
190: FROM jtf_ih_actions_tl
191: WHERE action = l_action_value
192: AND rownum < 2;
193: exception
194: when NO_DATA_FOUND then

Line 382: FROM jtf_ih_actions_tl

378: -- dbms_output.put_line ('Action=' || l_action_value);
379: -- Retreives the valid actionID for \223SR update\224 actions.
380: begin
381: SELECT nvl(action_id,0) into l_action_id
382: FROM jtf_ih_actions_tl
383: WHERE action = l_action_value
384: AND rownum < 2;
385: exception
386: when NO_DATA_FOUND then