APPS.ARCM_EXTRACT_XML_CF SQL Statements

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

Line: 126

			SELECT cr.credit_request_id,
	       		   cr.source_name, cr.source_column1,
	       		   cr.source_column2, cr.source_column3,
	       		   cr.source_user_id,
	       		   cr.source_resp_id,
	       		   cr.source_resp_appln_id,
	       		   cr.source_security_group_id,
	       		   cr.source_org_id
			FROM  ar_cmgt_credit_requests cr,
	      		  ar_cmgt_case_folders cf
			WHERE case_folder_id = P_CASE_FOLDER_ID
        	AND   cr.credit_request_id = cf.credit_request_id;

Line: 238

        l_list.DELETE;

Line: 300

     		Select 'Y'
     		INTO L_COUNT
     		from AR_CMGT_CASE_FOLDERS
     		WHERE CASE_FOLDER_ID = P_CASE_FOLDER_ID;

Line: 311

     	l_xml_query := 'SELECT CFD.CASE_FOLDER_ID,CFD.DATA_POINT_ID,
		 				DPD.DATA_POINT_NAME,CFD.DATA_POINT_VALUE,CFD.SCORE' ||
                       ' FROM AR_CMGT_CF_DTLS CFD,AR_CMGT_SCORABLE_DATA_POINTS_V DPD' ||
		     		   ' WHERE CASE_FOLDER_ID =ARCM_EXTRACT_XML_CF.get_case_folder_id' ||
		     		   ' AND CFD.DATA_POINT_ID = DPD.DATA_POINT_ID ' ;