APPS.IEX_CALL_HISTORY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 63

		    Select 	 JIIN.interaction_id			,
				         JIIN.start_date_time		,
					       JREV.resource_name
		    From		 JTF_IH_INTERACTIONS		JIIN	,
					       JTF_RS_RESOURCE_EXTNS_VL	JREV
		    where 	 JIIN.party_id = p_party_id
		    AND 		 JIIN.start_date_time
						     BETWEEN p_from_date and (p_to_date + 1)
		    AND		   JIIN.Resource_Id = JREV.resource_id
		    ORDER BY JIIN.start_date_time DESC ;

Line: 79

        		Select JIIN.interaction_id		,
				JIIN.start_date_time		,
				JREV.resource_name
		    From	JTF_IH_INTERACTIONS		JIIN	,
				JTF_RS_RESOURCE_EXTNS_VL	JREV,
                 		JTF_IH_ACTIVITIES JIA
		    where 	 JIA.cust_account_id = p_cust_account_id
        		AND      JIA.Interaction_Id = JIIN.Interaction_Id
        		AND		   JIIN.Resource_Id = JREV.resource_id
		    	AND 	   JIIN.start_date_time
					     BETWEEN p_from_date and (p_to_date + 1)
		    ORDER BY JIIN.start_date_time DESC ;

Line: 192

		v_activity_rec Activity_Select_Rec 	;

Line: 196

		   'Select
				JIA.interaction_id	,
				JIA.activity_id	,
				JIA.action_id		,
				JIA.outcome_id		,
				JIA.reason_id		,
				JIA.result_id		,
				JIA.duration		,
				JIA.doc_id		,
				JIA.doc_ref		,
				JIA.object_id		,
				JIA.object_type	,
				JIA.source_code_id	,
				JIA.source_code
		    From	JTF_IH_ACTIVITIES 		JIA
		    Where JIA.Interaction_id = :interaction_id' ;

Line: 301

			'Select Count(*)
			 from jtf_ih_activities
			 where Interaction_id = :Interaction_Id
			 AND   doc_ref = :doc_ref' ;

Line: 334

			'Select Short_Description
			 from JTF_IH_ACTIONS_VL
			 where Action_id = :Action_id' ;

Line: 362

			'Select Name
			 from JTF_Objects_vl
			 where object_code = :p_doc_ref' ;

Line: 388

			'Select Short_Description
			from JTF_IH_OUTCOMES_VL
			where Outcome_Id = :Outcome_Id' ;

Line: 417

			'Select Short_Description
			 from JTF_IH_REASONS_VL
			 where REASON_id = :REASON_id' ;

Line: 444

			'Select Short_Description
			 from JTF_IH_RESULTS_VL
			 where result_id = :result_id' ;