APPS.EAM_OP_COMP_DEFAULT_PVT SQL Statements

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

Line: 36

		   SELECT eam_op_completion_txns_s.nextval
		     INTO x_eam_op_comp_rec.transaction_id
		     FROM DUAL;

Line: 42

	          SELECT qa_collection_id_s.nextval
		    INTO x_eam_op_comp_rec.qa_collection_id
		    FROM DUAL;

Line: 48

		  SELECT sysdate
		    INTO x_eam_op_comp_rec.transaction_date
		    FROM DUAL;

Line: 75

		SELECT department_id INTO x_eam_op_comp_rec.department_id
		  FROM WIP_OPERATIONS
		 WHERE organization_id   = p_eam_op_comp_rec.organization_id
		   AND wip_entity_id     = p_eam_op_comp_rec.wip_entity_id
		   AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;