APPS.IEX_CALL_HISTORY dependencies on JTF_IH_REASONS_VL

Line 28: p_REASON_Desc OUT NOCOPY JTF_IH_REASONS_VL.Short_Description%TYPE) ;

24: p_Outcome_Desc OUT NOCOPY JTF_IH_OUTCOMES_VL.Short_Description%TYPE) ;
25:
26: Procedure Get_REASON_Description
27: (p_REASON_id IN Number,
28: p_REASON_Desc OUT NOCOPY JTF_IH_REASONS_VL.Short_Description%TYPE) ;
29:
30: Procedure Get_result_description
31: (p_result_id IN Number,
32: p_result_Desc OUT NOCOPY JTF_IH_RESULTS_VL.Short_Description%TYPE) ;

Line 408: -- description from JTF_IH_REASONS_VL view

404: ---------------------------------------------------------------------
405: -- GET_REASON_DESCRIPTION
406: ---------------------------------------------------------------------
407: -- Takes Action_id as parameter and returns the corresponding
408: -- description from JTF_IH_REASONS_VL view
409: ---------------------------------------------------------------------
410: Procedure Get_REASON_Description
411: (p_REASON_id IN Number,
412: p_REASON_Desc OUT NOCOPY JTF_IH_REASONS_VL.Short_Description%TYPE)

Line 412: p_REASON_Desc OUT NOCOPY JTF_IH_REASONS_VL.Short_Description%TYPE)

408: -- description from JTF_IH_REASONS_VL view
409: ---------------------------------------------------------------------
410: Procedure Get_REASON_Description
411: (p_REASON_id IN Number,
412: p_REASON_Desc OUT NOCOPY JTF_IH_REASONS_VL.Short_Description%TYPE)
413: IS
414: v_sql Varchar2(100) ;
415: Begin
416: v_sql :=

Line 418: from JTF_IH_REASONS_VL

414: v_sql Varchar2(100) ;
415: Begin
416: v_sql :=
417: 'Select Short_Description
418: from JTF_IH_REASONS_VL
419: where REASON_id = :REASON_id' ;
420:
421: EXECUTE IMMEDIATE v_sql
422: INTO p_reason_desc