APPS.EAM_WO_COMP_DEFAULT_PVT SQL Statements

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

Line: 40

	 SELECT eam_job_completion_txns_s.nextval
	   INTO x_eam_wo_comp_rec.transaction_id
	   FROM DUAL;

Line: 45

		 SELECT sysdate
		   INTO x_eam_wo_comp_rec.transaction_date
		   FROM DUAL;

Line: 51

		  SELECT qa_collection_id_s.nextval
		    INTO x_eam_wo_comp_rec.qa_collection_id
		    FROM DUAL;

Line: 81

	   SELECT asset_group_id
   	     INTO l_asset_group_id
	     FROM wip_discrete_jobs
	    WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;

Line: 94

	SELECT 	primary_item_id,
		asset_group_id,
		rebuild_item_id,
		asset_number,
		rebuild_serial_number,
		manual_rebuild_flag
	  INTO  x_eam_wo_comp_rec.primary_item_id,
	        x_eam_wo_comp_rec.asset_group_id,
		x_eam_wo_comp_rec.rebuild_item_id,
		x_eam_wo_comp_rec.asset_number,
		x_eam_wo_comp_rec.rebuild_serial_number,
		x_eam_wo_comp_rec.manual_rebuild_flag
	   FROM wip_discrete_jobs
	  WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;