APPS.BEN_CWB_WF_NTF dependencies on BEN_TRANSACTION

Line 15: FROM ben_transaction

11: l_transaction_id VARCHAR2(200);
12:
13: CURSOR c1(v_transaction_id IN VARCHAR2) IS
14: SELECT attribute40
15: FROM ben_transaction
16: WHERE transaction_type = 'BDGTNTF'
17: AND transaction_id = to_number(v_transaction_id);
18: BEGIN
19: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

Line 45: FROM ben_transaction

41: l_comment VARCHAR2(2000);
42: l_transaction_id VARCHAR2(200);
43: CURSOR c1(v_transaction_id IN VARCHAR2) IS
44: SELECT attribute40
45: FROM ben_transaction
46: WHERE transaction_type = 'APPRNTF'
47: AND transaction_id = to_number(v_transaction_id);
48: BEGIN
49: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

Line 75: FROM ben_transaction

71: l_comment VARCHAR2(2000);
72: l_transaction_id VARCHAR2(200);
73: CURSOR c1(v_transaction_id IN VARCHAR2) IS
74: SELECT attribute40
75: FROM ben_transaction
76: WHERE transaction_id = to_number(v_transaction_id);
77: BEGIN
78: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',
79: itemkey => p_transaction_id,