APPS.IEM_RULES_ENGINE_PUB dependencies on IEM_ACTION_DTLS

Line 19: -- lkullamb 07/13/2009 added parameter3 column to iem_action_dtls table, hence the procedure changed

15: -- Liang Xia 08/16/2004 Appending Rule_id for Document Retrieval to retrieval result later.( 11.5.10)
16: -- Liang Xia 04/06/2005 Fixed GSCC sql.46 ( bug 4256769 )
17: -- Liang Xia 06/24/2005 Fixed GSCC sql.46 ( bug 4452895 )
18: -- PKESANI 02/22/2006 ACSR project - code fix
19: -- lkullamb 07/13/2009 added parameter3 column to iem_action_dtls table, hence the procedure changed
20: -- auto_process_email
21: -- --------- ------ ------------------------------------------
22:
23: /*GLOBAL VARIABLES FOR PRIVATE USE

Line 271: from iem_actions a, iem_action_dtls b

267: --Get parameter(s)
268: cursor c_params(p_emailproc_id iem_emailprocs.emailproc_id%type)
269: is
270: select b.parameter1, b.parameter2,b.parameter3, b.parameter_tag
271: from iem_actions a, iem_action_dtls b
272: where a.action_id = b.action_id and a.emailproc_id = p_emailproc_id;
273:
274: --Verify that there are document under category for Document Mapping
275: BEGIN