APPS.OKC_AQ_PVT dependencies on OKC_ACTIONS_B

Line 31: FROM okc_actions_b

27: IS
28: CURSOR acn_cur
29: IS
30: SELECT acn_type
31: FROM okc_actions_b
32: WHERE correlation = p_corrid;
33: acn_rec acn_cur%ROWTYPE;
34: v_acn_type okc_actions_b.acn_type%TYPE;
35:

Line 34: v_acn_type okc_actions_b.acn_type%TYPE;

30: SELECT acn_type
31: FROM okc_actions_b
32: WHERE correlation = p_corrid;
33: acn_rec acn_cur%ROWTYPE;
34: v_acn_type okc_actions_b.acn_type%TYPE;
35:
36: --
37: l_proc varchar2(72) := ' OKC_AQ_PVT.'||'get_acn_type';
38: --

Line 848: FROM okc_actions_b acn

844: l_token2 VARCHAR2(50);
845: l_token2_value VARCHAR2(50);
846: CURSOR acn_cur IS
847: SELECT acn.id id
848: FROM okc_actions_b acn
849: WHERE acn.correlation = l_corrid.corrid;
850: acn_rec acn_cur%ROWTYPE;
851: e_dequeue_timeout EXCEPTION;
852: PRAGMA EXCEPTION_INIT (e_dequeue_timeout, -25228 );