APPS.IEX_CALL_HISTORY dependencies on JTF_IH_OUTCOMES_VL

Line 24: p_Outcome_Desc OUT NOCOPY JTF_IH_OUTCOMES_VL.Short_Description%TYPE) ;

20: p_Action_Desc OUT NOCOPY JTF_IH_ACTIONS_VL.Short_Description%TYPE) ;
21:
22: Procedure Get_OUTCOME_Description
23: (p_Outcome_Id IN Number,
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) ;

Line 383: p_Outcome_Desc OUT NOCOPY JTF_IH_OUTCOMES_VL.Short_Description%TYPE)

379: -- description from JTF_IH_ACTIONS_VL view
380: ---------------------------------------------------------------------
381: Procedure Get_OUTCOME_Description
382: (p_Outcome_Id IN Number,
383: p_Outcome_Desc OUT NOCOPY JTF_IH_OUTCOMES_VL.Short_Description%TYPE)
384: IS
385: v_sql Varchar2(100) ;
386: Begin
387: v_sql :=

Line 389: from JTF_IH_OUTCOMES_VL

385: v_sql Varchar2(100) ;
386: Begin
387: v_sql :=
388: 'Select Short_Description
389: from JTF_IH_OUTCOMES_VL
390: where Outcome_Id = :Outcome_Id' ;
391:
392: EXECUTE IMMEDIATE v_sql
393: INTO p_outcome_desc